/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

15 votes238 views4 answers
Sql update from select
SQL
0 vote271 views3 answers
Characters found after end of sql statement
SQL
0 vote231 views1 answer
Ora 00001 error catch plsql
SQL
0 vote247 views1 answer
Alter check command
SQL
3 votes245 views1 answer
Null sql
SQL
0 vote238 views1 answer
Sintaxis SELECT sql
SQL
3 votes239 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote347 views1 answer
Postgresql powershell query
SQL
-1 vote287 views4 answers
Full outer join in sql
SQL
0 vote233 views1 answer
Install ms sql server management studio
SQL