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
For Getting a Below output in sql how can i write queryinsql
narasiman rao
10y
710
1
Reply
In table records as follows
Facid Q1 Q2 Q3 Batchid
1 2 3 4 B001
2 4 4 5 B001
1 5 1 2 B002
2 4 5 3 B002
1 4 1 2 B003
2 5 4 3 B003
Using above records i want output as follows using sql query
B001 B002 B003
Facid Q1 Q2 Q3 Q1 Q2 Q3 Q1 Q2 Q3
1 2 3 4 5 1 2 4 1 2
2 4 4 5 4 5 3 5 4 3
for getting a above output how can i write a sql query.
please help me.
Regards
Narasiman
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
SOrting Data
How do i write an user authentication script?