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 vote168 views1 answer
Mysql where in keep order
SQL
0 vote180 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
1 vote166 views3 answers
How to get date in sql
SQL
0 vote184 views1 answer
Mysql get nth highest
SQL
6 votes215 views2 answers
Return columns from table sql
SQL
2 votes185 views5 answers
Tablespace ORACLE
SQL
0 vote150 views1 answer
How to find unique key in sql
SQL
7 votes170 views2 answers
Create index mysql
SQL
0 vote194 views1 answer
Sql server create constraint
SQL
6 votes180 views2 answers
Postgresql pg_dump
SQL