Can I transpose results in SQL just like I have it in excel. No hard coded values as I have different results every time.
For example, I have a table of employees and I want it to just convert rows into columns and columns into rows.
Thank you.
Asked
Active
Viewed 44 times
0
Sabyasachi Mishra
- 1,617
- 1
- 28
- 48
-
1Look into `PIVOT`. Also, which database are you using? – FutbolFan Sep 09 '15 at 17:29
-
2possible duplicate of [SQL Server dynamic PIVOT query?](http://stackoverflow.com/questions/10404348/sql-server-dynamic-pivot-query) – Evaldas Buinauskas Sep 09 '15 at 17:30
-
pivot works with wither group by or sum() or min() i want a simple table to transpose – Hamza Abdul Jabbar Sep 09 '15 at 17:46
-
The link you posted had hard coded values, it's mentioned that hard coded values wont work, I want all tables I selected to shift rows to columns – Hamza Abdul Jabbar Sep 09 '15 at 17:47
-
the link has dynamic sql utilized to pivot, it is not hard coded values. Additionally on the answer linked there is a stored procedure that will seemingly pivot data for you. – Kritner Sep 09 '15 at 18:07
-
Which DBMS are you using? Postgres? Oracle? – a_horse_with_no_name Sep 09 '15 at 20:44
-
i cannot use dynamic values i am not sure about the table's data in the future. – Hamza Abdul Jabbar Sep 10 '15 at 07:45