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 vote288 views1 answer
QCompleter con sql
SQL
0 vote253 views1 answer
Mysql database is not starting in xampp
SQL
2 votes275 views2 answers
Mysql show table column comments sql
SQL
2 votes275 views1 answer
Set column to not null mysql
SQL
0 vote268 views1 answer
Components/Fields of Internal Table
SQL
1 vote276 views1 answer
Sql how to duplicate a table
SQL
-1 vote287 views5 answers
Convert sql to linq query online
SQL
5 votes274 views3 answers
MySql get fields of table
SQL
1 vote276 views1 answer
Psql connections
SQL
0 vote298 views1 answer
What is server_default = func.now() in sqlalchemy
SQL