i have a problem

From: phoenix <abhishek.purkayastha_at_gmail.com>
Date: 1 May 2007 23:05:32 -0700
Message-ID: <1178085932.137182.162950@q75g2000hsh.googlegroups.com>

hi,
i have a problem,which i am unable to solve since yesterday.The problem is:-
i have a table with coulmns A,B,C,D,E

and along with data it looks like         A     B     C     D     E
                                                      10    20
30    40   50
                                                      20    100  1000
40  40
                                      and so
on ...        ...   ....   ....   ...

i want a query by which i can get a output like

A 10 20 ... ....
B 20 100 ....  ...
C 30  1000.... ....

D 40 40 ....
E 50 40

i.e basically converting the columns into rows.

can anyone suggest me a solution for the above problem?? Received on Wed May 02 2007 - 01:05:32 CDT