/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 vote314 views1 answer
Get last three characters in mysql column
SQL
0 vote270 views1 answer
Declaring variables in pl sql
SQL
0 vote277 views1 answer
Oracle select invalid views
SQL
1 vote302 views1 answer
Too many connections mysql
SQL
0 vote296 views1 answer
Get first 3 letter of department name in sql
SQL
6 votes366 views2 answers
Oracle compile trigger
SQL
0 vote284 views1 answer
Describe in sqlite3
SQL
1 vote299 views3 answers
Mysql Server Start
SQL
2 votes294 views1 answer
Add new column not null sql server
SQL
0 vote318 views1 answer
Drop tables from local database postgres pgadmin
SQL