Loading

SQL,column header

Sreekanth

16y3.1kSQL

hi,
this is ma table

column1 column2 column3
A P1 1
A P2 2
A P3 3
B P1 4
B P2 5
B P3 6
D P1 7
E P2 8
F P3 9

i need a select query which givs reslut likethis:

if ma "where" condition is, column2=p1
column1 P1
A 1
B 4
D 7,

iif ma "where" condition is, column2=p2

columns1 P2
A 2
B 5
E 8

help me pls!!!!!!!!!!

1 Reply

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

Dipa Ahuja16y ago
So that mean you want to change the header of the column while displaying the query result?

you using web app. or windows app. or just querying in SQL?

coz in in web app. you display records in data control and from that you may change the header of the column
0