/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 vote210 views1 answer
Sql query to force the database to be drop
SQL
0 vote198 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote217 views1 answer
Sqlalchemy query sql compiled
SQL
4 votes175 views1 answer
Sql list users and roles
SQL
0 vote208 views2 answers
Unique key
SQL
3 votes202 views2 answers
Pl sql escape '
SQL
2 votes236 views2 answers
Null column to 0 in mysql
SQL
13 votes192 views5 answers
Oracle list tables
SQL
1 vote212 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote187 views8 answers
Convert sql query to linq online
SQL