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 vote152 views1 answer
Sql character index
SQL
4 votes141 views1 answer
Sql any
SQL
0 vote200 views1 answer
MySQL update with subquery
SQL
2 votes149 views1 answer
Oracle index size
SQL
-1 vote147 views1 answer
Mysql order by on condition
SQL
0 vote177 views1 answer
What is common table expression in sql
SQL
0 vote156 views2 answers
Null value in column violates not-null constraint
SQL
0 vote151 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote148 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote251 views1 answer
Como verificar registros duplicados no sql postgresql
SQL