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 vote338 views1 answer
Add alternate add column sql
SQL
0 vote326 views1 answer
Update set with join pl sql
SQL
0 vote323 views1 answer
Postgresql parse json array
SQL
11 votes341 views2 answers
Oracle all source
SQL
1 vote349 views1 answer
Sql find column name like
SQL
0 vote339 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
21 votes335 views6 answers
Docker run mysql
SQL
0 vote402 views2 answers
How to install psql in ubuntu
SQL
0 vote363 views1 answer
Convert int to varchar sql
SQL
37 votes355 views3 answers
Duplicate records in sql
SQL