/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

0 vote137 views1 answer
Select row with latest date mysql
SQL
0 vote140 views1 answer
Mysql change innodb to myisam
SQL
32 votes133 views6 answers
Sql count where
SQL
0 vote142 views1 answer
Sql server for loop
SQL
0 vote140 views1 answer
Select nth row in mysql
SQL
0 vote153 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
0 vote129 views2 answers
Temp tables in sql server
SQL
1 vote137 views1 answer
Rermove categories woocommerce sql
SQL
40 votes202 views4 answers
PostgreSQL add column
SQL
24 votes152 views4 answers
Delete db postgres
SQL