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 vote276 views1 answer
Mysql regex exact match
SQL
1 vote286 views1 answer
Multiple count in sql
SQL
0 vote310 views1 answer
How to map sql column to custom names
SQL
1 vote317 views1 answer
Insert many to many sql
SQL
0 vote274 views1 answer
2020 new year
SQL
9 votes284 views4 answers
Last mysql
SQL
6 votes269 views1 answer
How to count number of rows in sql
SQL
0 vote287 views1 answer
Oracle sql drop table
SQL
0 vote310 views1 answer
Mysql sum per week
SQL
13 votes270 views2 answers
Sqlite rename column
SQL