/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

1 vote202 views1 answer
Show structure of table in sql
SQL
0 vote217 views1 answer
Netstat -tln mysql
SQL
6 votes237 views3 answers
Psql show columns of table
SQL
0 vote190 views1 answer
List mysql tables and views
SQL
0 vote205 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote203 views2 answers
Import .sql into postgres db command
SQL
6 votes218 views1 answer
How to get the size of the database in postgresql
SQL
0 vote187 views1 answer
Mysql count grouped rows
SQL
0 vote206 views1 answer
Sqlite trim
SQL
1 vote193 views1 answer
Rermove categories woocommerce sql
SQL