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 vote148 views1 answer
Mysql connect bash
SQL
0 vote152 views1 answer
Mysql update from select on same table
SQL
2 votes145 views1 answer
Mysql last 7 days including today
SQL
0 vote145 views1 answer
Sql query to check if column contains alphabets
SQL
0 vote147 views1 answer
Sql query to force the database to be drop
SQL
0 vote151 views1 answer
Download sql file of countries names
SQL
0 vote130 views1 answer
Knex last insert id mysql
SQL
0 vote155 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote147 views1 answer
Drop-toys-table
SQL
3 votes287 views6 answers
Sql unique select
SQL