/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

33 votes362 views6 answers
Change column name in mysql
SQL
5 votes377 views1 answer
Add column table sql default value
SQL
0 vote382 views1 answer
T-sql update table variale
SQL
9 votes366 views6 answers
Replace sql
SQL
0 vote363 views1 answer
What does leave do in mysql
SQL
0 vote379 views2 answers
Default constraint in ms sql
SQL
4 votes334 views1 answer
Psql get sequences
SQL
1 vote345 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote359 views2 answers
How to type a blank discord messgae
SQL
1 vote386 views2 answers
Sql server backup table
SQL