/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 vote156 views1 answer
Oracle rolling back transactions
SQL
0 vote238 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote211 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote149 views1 answer
Get who is hired in january in sql
SQL
0 vote159 views1 answer
Postegresql update to null
SQL
0 vote189 views1 answer
Wordpress make wp user in db
SQL
0 vote144 views1 answer
Group by 15 minute interval sql server
SQL
0 vote241 views1 answer
ORA-00942
SQL
0 vote157 views1 answer
Oracle current timestamp insert statement
SQL
0 vote159 views1 answer
Sql max min
SQL