/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 vote96 views1 answer
Oracle 11g forget password
SQL
1 vote108 views1 answer
Alter table column size oracle
SQL
0 vote117 views1 answer
Mysql add root password
SQL
0 vote118 views3 answers
How to assign custom id in mysql
SQL
1 vote111 views2 answers
Pad zero sql server
SQL
0 vote112 views1 answer
Create synonym for dblink in oracle
SQL
6 votes105 views1 answer
Oracle list primary key
SQL
3 votes109 views1 answer
How to check schema privileges in oracle
SQL
6 votes113 views3 answers
Mysql first day of year
SQL
0 vote135 views1 answer
Insert into table with only identity column
SQL