/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 votes278 views1 answer
Mysql not empty
SQL
22 votes299 views4 answers
Mysql date_format
SQL
9 votes284 views2 answers
Sql limit order by
SQL
0 vote318 views1 answer
Having all mysql
SQL
0 vote295 views1 answer
Into operator in sql
SQL
0 vote287 views1 answer
Oracle current session details
SQL
1 vote281 views3 answers
Mysql disable foreign keys check
SQL
0 vote264 views1 answer
Get all employees if name ends with in sql
SQL
1 vote301 views1 answer
Postgres power
SQL
0 vote278 views1 answer
Select last 2 characters sql
SQL