I can't figure this out, Please help...
SQL Problem --
We have a table of orders.
CREATE TABLE Orders (ordernumber INT, rownumber INT, Description VARCHAR(10))
The rownumber is guaranteed to always between 1 and 5 and is always filled in consecutively.
Write SQL that will return the rownumbers as column headers, with the description as the column values. Output similar to below:
Order# Row1 Row2 Row3 Row4 Row5
10 Desc1 Desc2
20 Desc1 Desc2 desc3
Please help... Thanks!