/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 vote269 views1 answer
Mac os zsh: command not found: mysql
SQL
6 votes232 views2 answers
Mysql 1 day ago
SQL
0 vote255 views1 answer
How to find unique element in sql
SQL
2 votes238 views2 answers
Storing timezones in postgres
SQL
1 vote191 views1 answer
Order by oracle
SQL
1 vote205 views2 answers
Mysql extract month
SQL
5 votes244 views1 answer
How to check port number for postgresql
SQL
0 vote208 views1 answer
Mysqldump don't drop table
SQL
0 vote239 views1 answer
Postgres docs /copy metacomand
SQL
0 vote231 views1 answer
When mysql server would not work in xampp
SQL