Hi,
I have some data in rows which I want them in columns. Below is an
example:
col1 col2 col3
------ ----- -----
table length 45
table breadth 50
table height 60
chair length 15
chair breadth 25
chair height 20
I want this data in this format:
col1 length breadth height
----- -------- ---------- --------
table 45 50 60
chair 15 25 20
Can someone help in getting this o/p using SQL queries?
Thanks.
Saurabh