/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 votes140 views3 answers
Mysql pass command from command line
SQL
0 vote150 views1 answer
SELECT statement to find the specific cell in database table
SQL
1 vote139 views1 answer
PL SQL MODIFY COLUMN NME
SQL
6 votes171 views3 answers
Mysql change auto_increment start value
SQL
4 votes158 views4 answers
Remove duplicate old value in mysql
SQL
0 vote130 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote188 views1 answer
Sql server system messeges
SQL
0 vote133 views1 answer
Postgres list tables and row counts
SQL
0 vote149 views1 answer
Creating h2 database in relative directory eclopse
SQL
0 vote128 views1 answer
Default column value in sql same as other column
SQL