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 vote109 views1 answer
Two inner joins sql
SQL
15 votes115 views6 answers
Drop foreign key mysql
SQL
0 vote93 views1 answer
Update set with inner join oracle
SQL
0 vote115 views1 answer
Sql server synonym
SQL
0 vote110 views1 answer
Stop psql server windows
SQL
1 vote98 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
13 votes123 views3 answers
Sql select from multiple tables without join
SQL
5 votes110 views1 answer
Purge undo tablespace usage
SQL
16 votes105 views1 answer
Mssql int max value
SQL
12 votes98 views1 answer
Psql drop column
SQL