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 vote317 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
1 vote205 views1 answer
Psql datetime grather than
SQL
2 votes221 views1 answer
How to delete columns in sql
SQL
-1 vote212 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote229 views1 answer
Postgresql custom order by
SQL
0 vote214 views1 answer
How to find sql server installation folder
SQL
0 vote237 views1 answer
Mysql date without time
SQL
0 vote202 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
1 vote184 views1 answer
Delete triger pl pg sql
SQL
1 vote217 views1 answer
Database Queries
SQL