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

0 vote217 views1 answer
Postgres regex word boundary
SQL
0 vote227 views1 answer
How to update date value in sql
SQL
0 vote228 views1 answer
Hour and minute between two datatime sql
SQL
0 vote212 views1 answer
How convert into in in sql query
SQL
2 votes205 views1 answer
Date conversion in mysql column
SQL
0 vote209 views1 answer
Mysql default timestamp value to be current timestamp
SQL
0 vote225 views1 answer
Mysql update from select on same table
SQL
0 vote201 views1 answer
Sql value exists in column
SQL
2 votes211 views2 answers
Sqlalchemy filter or
SQL
0 vote221 views1 answer
How to locate pg_hba.conf file
SQL