/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

4 votes215 views1 answer
How to check last gather stats on table in oracle
SQL
1 vote167 views1 answer
Show all event schedular on mysql
SQL
0 vote174 views1 answer
Sql order by number not ordered
SQL
0 vote181 views1 answer
Postgresql comandos basicos
SQL
0 vote168 views1 answer
Postgresql delete multiple rows
SQL
1 vote168 views1 answer
Rermove categories woocommerce sql
SQL
7 votes173 views3 answers
Select latest entry in sql table
SQL
6 votes167 views3 answers
Mysql server is not starting xampp
SQL
0 vote177 views1 answer
Set a value by excuting stored procedure
SQL
0 vote186 views1 answer
Sql ssrs
SQL