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 vote194 views1 answer
Postgres convert exisiting column to text
SQL
0 vote191 views1 answer
How to export table data from mysql table in sql format
SQL
1 vote189 views1 answer
Python escape mysql
SQL
0 vote209 views1 answer
Sql #region
SQL
0 vote239 views1 answer
Display all node label neo4j
SQL
1 vote222 views1 answer
Drop colum oracle 18c
SQL
21 votes191 views3 answers
Sql average
SQL
0 vote207 views1 answer
Add a new column into table
SQL
11 votes192 views1 answer
Oracle view ddl
SQL
1 vote171 views2 answers
Get date from datetime postgresql
SQL