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

3 votes146 views2 answers
Synonym oracle
SQL
3 votes123 views4 answers
Truncate syntax in sql
SQL
0 vote117 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote119 views1 answer
SQL column name Oracle
SQL
0 vote132 views1 answer
Sql last 3 rows
SQL
2 votes134 views1 answer
Create delete procedure mysql
SQL
5 votes126 views1 answer
Purge undo tablespace oracle 11g
SQL
0 vote140 views1 answer
Cannot start database server xampp mac os
SQL
3 votes140 views1 answer
Select table column in sql
SQL
0 vote136 views1 answer
WHERE not regex in SQL
SQL