/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 vote322 views1 answer
Storing RGBA in mysql db
SQL
6 votes350 views1 answer
How to get the size of the database in postgresql
SQL
0 vote349 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
5 votes333 views4 answers
Mysql on duplicate key update
SQL
0 vote320 views1 answer
Postgresql if else endif
SQL
9 votes341 views6 answers
Check constraint in sql
SQL
5 votes346 views1 answer
Mysql last day of next month
SQL
1 vote353 views1 answer
Oracle compile schema
SQL
4 votes356 views1 answer
Conda install sqlalchemy
SQL
0 vote392 views2 answers
Check if sql temp table exists
SQL