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 vote245 views1 answer
How to check common records in 2 table
SQL
0 vote152 views1 answer
Como leer datos de mysql esp32
SQL
0 vote169 views2 answers
How to update the multiple rows in sql
SQL
-1 vote179 views1 answer
Sql oracle take only last results
SQL
0 vote175 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote165 views1 answer
Postgressql uuid
SQL
0 vote179 views1 answer
Can't connect to postgresql mac os
SQL
0 vote178 views1 answer
Hoq to import database source
SQL
0 vote214 views2 answers
Sql unique
SQL
16 votes165 views3 answers
Delete row psql
SQL