/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 vote180 views1 answer
What is in condition in sql
SQL
1 vote298 views1 answer
Concat first name and last name in mysql
SQL
0 vote184 views1 answer
10000000000000000000 am to meters
SQL
0 vote211 views1 answer
Mysql dump for selected row
SQL
0 vote198 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
3 votes235 views2 answers
Find string in stored procedure sql server
SQL
1 vote179 views1 answer
Mariadb alter user host
SQL
0 vote191 views1 answer
Mysql 8 error on identified by
SQL
0 vote191 views1 answer
Sqlite explain plan
SQL
0 vote134 views2 answers
Sql query unique
SQL