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

16 votes246 views3 answers
Order by sql query
SQL
11 votes194 views2 answers
Insert current date sql
SQL
1 vote178 views1 answer
Scaffold mysql database
SQL
0 vote337 views1 answer
How to find the most occuring in SQL
SQL
2 votes188 views3 answers
Mysql pass command from command line
SQL
0 vote245 views3 answers
Sql parenthetical expression examples
SQL
0 vote212 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
-1 vote201 views1 answer
Count occurrences sql
SQL
0 vote175 views5 answers
Sql table intermédiaire
SQL
14 votes190 views2 answers
Oracle limit rows
SQL