/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 vote212 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote208 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
27 votes199 views3 answers
Mysql show tables in database
SQL
17 votes180 views2 answers
T_sql contains
SQL
0 vote191 views1 answer
Query for backup a database at another location in file system
SQL
0 vote177 views2 answers
Change database postgres
SQL
0 vote175 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote167 views1 answer
Pl sql constraint user function
SQL
0 vote168 views1 answer
Sql get number of days between two dates
SQL
3 votes204 views3 answers
Docker create postgresql database
SQL