/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 vote256 views1 answer
Mysql money value
SQL
5 votes285 views4 answers
Upload database mysql command line
SQL
4 votes245 views1 answer
SQL order random
SQL
0 vote267 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote257 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote256 views1 answer
Rabbitmq service not starting
SQL
6 votes252 views1 answer
Postgresql get year
SQL
0 vote248 views1 answer
Update set with join pl sql
SQL
0 vote266 views1 answer
Mysql workbench indent formatting
SQL
3 votes275 views2 answers
Mysql import gz
SQL