/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 votes297 views2 answers
Spring import sql
SQL
1 vote277 views1 answer
Postgresql create table with timestamp
SQL
0 vote273 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote281 views2 answers
Postgres having
SQL
16 votes321 views1 answer
Sqlserver add column to table
SQL
0 vote293 views1 answer
Materialized view redshift
SQL
2 votes280 views1 answer
How to create sql database
SQL
0 vote268 views2 answers
Database owner can't create new tables postgres
SQL
1 vote263 views1 answer
Sql injection
SQL
-1 vote284 views1 answer
Extract Data from SQL Server into XML Format
SQL