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

1 vote127 views1 answer
How to change owner in postgres
SQL
0 vote167 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote127 views1 answer
Oracle last connection
SQL
0 vote126 views1 answer
Sql select maximum column with other columns returned
SQL
2 votes169 views1 answer
Flask sqlalchemy boolean field
SQL
0 vote146 views1 answer
Mysql utc timestamp
SQL
0 vote90 views1 answer
Update set with join pl sql
SQL
1 vote115 views1 answer
How to delete data from sql database in android
SQL
0 vote131 views1 answer
Flush user resource mysql
SQL
0 vote157 views1 answer
When mysql server would not work in xampp
SQL