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 votes202 views4 answers
Show databases in sql server
SQL
5 votes193 views1 answer
Oracle nls parameters
SQL
9 votes193 views3 answers
Show table columns mysql command line
SQL
0 vote160 views3 answers
Mysql calculate age from date of birth
SQL
0 vote205 views1 answer
Datatables server side filter where clause
SQL
0 vote200 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote246 views2 answers
Fanyi
SQL
0 vote247 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote183 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
25 votes196 views5 answers
Uninstall mysql ubuntu
SQL