/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

0 vote132 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
5 votes112 views1 answer
Oracle list days between two dates
SQL
0 vote102 views4 answers
Mysql on kubernetes
SQL
6 votes105 views1 answer
Sqlite foreign key
SQL
0 vote104 views1 answer
Sql datediff db2
SQL
7 votes110 views3 answers
Foreign key oracle
SQL
1 vote130 views2 answers
Mysql does sentance contain word
SQL
0 vote127 views1 answer
Sql_inner_join
SQL
0 vote118 views1 answer
T sql dynamic top n query
SQL
0 vote115 views1 answer
Postgresql linux password
SQL