/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

2 votes109 views1 answer
Can you use a where clause for a child query
SQL
1 vote106 views1 answer
How to check the mysql version mac
SQL
3 votes125 views3 answers
Postgresql random number
SQL
5 votes121 views1 answer
AND OR NOT operators sql
SQL
0 vote122 views1 answer
Exec procedure oracle
SQL
0 vote120 views1 answer
Update top 100 order by sql server
SQL
0 vote115 views1 answer
Install package for sqlserver in asp.net core
SQL
9 votes102 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote106 views1 answer
Select password from user mysql
SQL
0 vote114 views1 answer
Implicit inner join table alias with id values
SQL