I have a table like this
DATE COLUMN-A COLUMN-B COLUMN-C
01/12/2004 23 25 76
01/13/2004 12.12 34.234 56
01/14/2004 12 24 46
01/15/2004 26 255 12.3
My requirment is, need to generate a report with SQL statement as follow's
01/12/2004 01/13/2004 01/14/2004 01/15/2004
COLUMN-A 23 12.12 12 26
COLUMN-B 25 34.234 24 255
COLUMN-C 76 56 46 12.3
Thanks in Advance.