/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

1 vote286 views1 answer
Mysql collation
SQL
0 vote302 views1 answer
Oracle db get table sizes
SQL
4 votes311 views2 answers
Oracle unlock user
SQL
0 vote303 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
1 vote328 views1 answer
Update from table tsql
SQL
3 votes321 views1 answer
Uppercase and lowercase in sql
SQL
0 vote316 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote285 views1 answer
Oracle execute immediate quotes
SQL
0 vote312 views1 answer
Pl/ sql change currency
SQL
25 votes324 views6 answers
Import mysql database command line
SQL