How can we transpose a table using SQL (changing rows to column) ?

Answer 1

The usual way to do it in SQL is to use CASE statement or DECODE statement.

Answer 2

can't we use with pivot?

Answer 3

simply you can create temporary tables and write left outer join ,you will get multiple columns

Answer 4

We can use a PIVOT command but it is more complicated.