/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 vote149 views1 answer
Systems sql
SQL
1 vote144 views1 answer
Ef core 5.0 usesqlserver not found
SQL
3 votes145 views1 answer
Sql cast to integer
SQL
22 votes165 views3 answers
Sql cheat sheet
SQL
0 vote131 views1 answer
Update set with inner join oracle
SQL
0 vote140 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote173 views1 answer
Mysql get hour from datetime
SQL
0 vote232 views1 answer
Database timezone
SQL
4 votes137 views1 answer
Restart for pg_hba.conf file
SQL
1 vote153 views1 answer
Top 10 rows in mysql
SQL