Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
For Getting a Below output in sql how can i write queryinsql
narasiman rao
Jun 16 2014 1:30 PM
689
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
SOrting Data
How do i write an user authentication script?