/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 vote167 views1 answer
Select top 3 sql
SQL
0 vote141 views1 answer
Mysql get 2nd value in comma separated list
SQL
1 vote159 views1 answer
Oracle create_program
SQL
36 votes151 views6 answers
Delete from where sql
SQL
0 vote144 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote170 views1 answer
Sql query tags
SQL
0 vote159 views2 answers
Null value in column violates not-null constraint
SQL
0 vote152 views1 answer
Mysql procedure between two tables
SQL
0 vote162 views1 answer
Install sql server in ubuntu 20.04
SQL
1 vote160 views1 answer
Quit mysql
SQL