Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Answer
convert sql query rows to columns
satish hirpara
10y
673
1
Reply
Hello , following is my table data :
EmployeeDetailID Name AbsentDays Month
3 Vishal Patel 1 May-13
3 Vishal Patel 3 Jun-13
3 Vishal Patel 4 Jul-13
Now i want this data to be converted like below :
EmployeeDetailID Name May-13 Jun-13 Jul-13
3 Vishal Patel 1 3 4
Please help me out with the query and thnx in advance
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
SQL QUARIE NOT SELECT 'NULL' AND '0' VALUES IN COLOUMS
How to fetch recently added record in sql