/SQL/Convert rows to columns in sql server

Convert rows to columns in sql server

-- convert rows to columns in sql server (PIVOT)
SELECT Firstname, Amount, PostalCode
FROM (
         SELECT value, columnname
         FROM yourtable
     ) d
PIVOT (
    max(value)
    FOR columnname IN (Firstname, Amount, PostalCode)
) piv;

Similar codes

3 votes360 views1 answer
Oracle get trigger ddl
SQL
2 votes357 views1 answer
Oracle drop sequence if exists
SQL
0 vote369 views1 answer
Sql server remove enter from string
SQL
0 vote360 views1 answer
Check if table exists oracle
SQL
10 votes359 views2 answers
Linux command line import mysql database
SQL
1 vote353 views2 answers
Oracle list partitioned tables
SQL
25 votes449 views5 answers
Mysql replace text
SQL
1 vote358 views1 answer
Set all the vluses in calumn in sql to false
SQL
1 vote339 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote341 views1 answer
Sql python hwo to pass a list in paramerter
SQL