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

1 vote216 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
-1 vote202 views1 answer
Io
SQL
0 vote202 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote209 views1 answer
Query string starts with vowels
SQL
0 vote190 views1 answer
Postgres list tables and row counts
SQL
1 vote200 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
1 vote221 views1 answer
How do you use sql in you company
SQL
0 vote188 views1 answer
Postgres create extension if not exists
SQL
20 votes189 views3 answers
SQL query rename table
SQL
0 vote199 views3 answers
Query string not ending with with vowels
SQL