Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
how to do convert rows into columns
narasiman rao
Mar 18 2017 9:11 AM
217
Reply
i have emp table as follows
Empid Empname Month Salary
1 A 1 3000
2 B 2 5000
3 C 3 8000
4 D 4 9000
5 E 5 7000
from the above i want the output as follows
Empid Empname 1 2 3 4 5
1 A 3000 5000 8000 9000 7000
from getting a above output how to write the query in sql server
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
how to get the between date using from date and to date
when i am creating a trigger shows error