Sql pivot without aggregate

WITH pivot_data AS
(
SELECT customerid, -- Grouping Column
dbcolumnname, -- Spreading Column
data -- Aggregate Column
FROM pivot2 
)
SELECT customerid, [firstname], [middlename], [lastname]
FROM pivot_data
PIVOT (max(data) FOR dbcolumnname IN ([firstname],[middlename],[lastname])) AS p;

Source: stackoverflow.com

Similar codes

0 vote323 views1 answer
Back up stored procedures mysql
SQL
0 vote339 views1 answer
Mysql_union
SQL
0 vote325 views1 answer
Select top 3 sql
SQL
2 votes397 views1 answer
Remove foreign key constraints in postgres
SQL
2 votes346 views2 answers
Sql percentage
SQL
1 vote328 views1 answer
Mysql select month and year
SQL
3 votes468 views1 answer
How to get yesterday date in sql
SQL
0 vote323 views1 answer
Nueva tabla mysql
SQL
0 vote421 views1 answer
Jpa generationtype sequence mysql
SQL
1 vote387 views1 answer
UseSqlServer no definition
SQL