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

50 votes292 views6 answers
Sql count duplicate rows
SQL
11 votes193 views2 answers
How to import mysql database command line
SQL
2 votes189 views1 answer
Oracle to_char number format percentage
SQL
1 vote124 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote174 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote192 views1 answer
Install sql server in ubuntu 20.04
SQL
13 votes169 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote254 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote162 views2 answers
How to start postgresql laravel
SQL
9 votes183 views5 answers
Sql delete duplicate rows but keep one
SQL