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
2
Answers
how to do convert rows into columns
narasiman rao
7y
235
1
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
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