/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

6 votes142 views1 answer
Sqlite foreign key
SQL
0 vote149 views1 answer
Custom row number
SQL
0 vote140 views1 answer
RowDataPacket
SQL
3 votes147 views1 answer
Sql double index
SQL
0 vote142 views1 answer
Sql tabelle erstellen
SQL
0 vote166 views2 answers
Sql if empty then
SQL
4 votes137 views2 answers
Sql table
SQL
0 vote147 views1 answer
Load data from text file to mysql database on mac terminal
SQL
1 vote177 views1 answer
Apex run 404
SQL
24 votes145 views6 answers
Sql change table name
SQL