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

6 votes218 views2 answers
Clear a table in mysql
SQL
2 votes171 views1 answer
Sql float to int
SQL
0 vote238 views1 answer
Delete duplicate rows
SQL
3 votes169 views1 answer
How to get list of synonyms in oracle
SQL
1 vote200 views1 answer
Mysql count words
SQL
2 votes226 views3 answers
Postgres create view
SQL
3 votes209 views1 answer
Sql multiple column index
SQL
0 vote215 views1 answer
Android sqlite get rows count
SQL
0 vote239 views4 answers
Restart MySQL
SQL
4 votes348 views6 answers
Laravel jwt
SQL