/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 votes213 views1 answer
Postgresql group by month and year
SQL
1 vote170 views1 answer
Postgresql convert text to float
SQL
0 vote196 views1 answer
Count in sql and diff
SQL
4 votes171 views2 answers
Sql select except null
SQL
0 vote170 views1 answer
Sql change date format
SQL
0 vote175 views1 answer
Top 3 salary in sql
SQL
0 vote183 views1 answer
Selecting from a view SQL
SQL
0 vote188 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote187 views1 answer
Add computed column to table sql server
SQL
4 votes184 views1 answer
Describe table mysql
SQL