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 vote234 views1 answer
Tsql generate rows
SQL
0 vote239 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote248 views1 answer
Normalization in database
SQL
0 vote212 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote232 views2 answers
Starting mysql service from mac
SQL
0 vote232 views1 answer
Mysql add root password
SQL
0 vote230 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote240 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote234 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
6 votes234 views1 answer
To count number of rows in SQL table
SQL