/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 vote203 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote188 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote237 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote178 views1 answer
Close sql query vb.net
SQL
15 votes183 views1 answer
Mysql int range
SQL
0 vote174 views6 answers
Unique key in sql
SQL
13 votes176 views2 answers
Mysql order by multiple columns
SQL
0 vote193 views1 answer
Check if database exists sql
SQL
0 vote175 views1 answer
In mysql workbench contnent not feching
SQL
1 vote210 views1 answer
T-sql disable system versioning
SQL