/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

2 votes367 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
1 vote322 views1 answer
Mysql select utc time in eastern time
SQL
0 vote348 views1 answer
Sql server alter table column nullable
SQL
1 vote355 views1 answer
Mysql check string don't have number
SQL
0 vote397 views1 answer
Consecutive numbers sql
SQL
0 vote341 views1 answer
Sql create table with datetime automatically
SQL
4 votes339 views1 answer
Delete record mysql query
SQL
1 vote384 views1 answer
Alter constraint in sql
SQL
0 vote360 views1 answer
Get a list of tables and the primary key
SQL
0 vote335 views1 answer
Mysql_num_fields in mysqli
SQL