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

2 votes139 views1 answer
Oracle sql day of month from date
SQL
8 votes140 views1 answer
Alter tablespace add datafile
SQL
3 votes112 views1 answer
Ubuntu install postgresql 12
SQL
3 votes141 views1 answer
Two selects in one query
SQL
0 vote147 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote139 views1 answer
Oracle list of long running queries
SQL
0 vote180 views1 answer
Calculer pourcentage mysql
SQL
0 vote142 views1 answer
Oracle create job if not exists
SQL
0 vote155 views1 answer
Mysql default uuid
SQL
-1 vote158 views1 answer
Adding a new table psql
SQL