/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

14 votes274 views4 answers
Import database through command line
SQL
0 vote254 views1 answer
Recover deleted data from mysql database
SQL
1 vote301 views1 answer
Delete mysql ubuntu 20.04
SQL
1 vote247 views2 answers
DROP TABLes regardless of constraints
SQL
2 votes268 views1 answer
Oracle list duplicates
SQL
0 vote262 views1 answer
Test database for sql
SQL
-2 votes254 views2 answers
Sqlserver docker
SQL
1 vote249 views2 answers
Replace text in sql
SQL
3 votes271 views3 answers
Mysql declare variable
SQL
0 vote262 views1 answer
How to print mysql query of codeigniter query builder
SQL