/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

7 votes328 views1 answer
Append column sql
SQL
0 vote328 views1 answer
Sum value by month sql
SQL
11 votes317 views2 answers
Sql rank
SQL
1 vote352 views1 answer
Sql order by where condition
SQL
0 vote349 views1 answer
Assign value to var in SQL
SQL
0 vote348 views2 answers
Mysql create table if not exists
SQL
1 vote349 views1 answer
Check current sequence value postgres
SQL
0 vote334 views1 answer
Mysql select where field like in list
SQL
0 vote322 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
2 votes351 views2 answers
Enable foreign key checks postgres
SQL