/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 vote192 views1 answer
Truncate table in postgresql and reset id
SQL
7 votes203 views1 answer
Oracle alter sequence restart start with
SQL
1 vote140 views1 answer
Mysql not supported auth mode
SQL
19 votes117 views6 answers
Sql create table
SQL
0 vote109 views1 answer
Get who is hired in month in sql
SQL
7 votes146 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
0 vote126 views2 answers
Connect to mysql server mac terminal
SQL
0 vote146 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote129 views1 answer
Implicit inner join table alias
SQL
1 vote122 views2 answers
Mysql join two tables
SQL