/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 votes282 views1 answer
Sql compare strings
SQL
0 vote227 views1 answer
Ms sql database data size
SQL
0 vote230 views1 answer
Sql server concat null
SQL
0 vote227 views1 answer
Datagrip exec
SQL
1 vote223 views2 answers
Sql where is not number
SQL
0 vote239 views1 answer
Name '_mysql' is not defined
SQL
1 vote237 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote170 views1 answer
Oracle sql replace string in clob
SQL
0 vote198 views2 answers
Sql update from two different database
SQL
1 vote234 views1 answer
Create table tablename as select * from tablename
SQL