Sql server pivot rows to columns

select Firstname, Amount, PostalCode, LastName, AccountNumber
from
(
  select value, columnname
  from yourtable
) d
pivot
(
  max(value)
  for columnname in (Firstname, Amount, PostalCode, LastName, AccountNumber)
) piv;

Similar codes

3 votes145 views1 answer
Query less than datetime sql
SQL
4 votes110 views1 answer
Change nls_date_format
SQL
0 vote123 views2 answers
Sql max count
SQL
1 vote106 views1 answer
Delete mysql from mac
SQL
0 vote110 views1 answer
Get clob size oracle
SQL
2 votes113 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote88 views1 answer
Duplicate foreign key constraint name
SQL
2 votes112 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote135 views1 answer
Varchar2 length in oracle
SQL
2 votes116 views1 answer
Sql server find columns list in tables
SQL