Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Post
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Reply
convert sql query rows to columns
satish hirpara
10 years ago
664
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