Loading

For Getting a Below output in sql how can i write queryinsql

narasiman rao

12y1.3k

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.