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 vote355 views1 answer
How to select rows with no matching entry in another table?
SQL
4 votes398 views1 answer
Rename stored procedure in sql server
SQL
0 vote347 views1 answer
Java spring boot connect to sql server
SQL
4 votes373 views6 answers
Sql select statement
SQL
1 vote412 views1 answer
Oracle see column type
SQL
0 vote338 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote355 views1 answer
Prepared statement mysql java delete selected rows
SQL
5 votes366 views3 answers
Oracle first day of last year
SQL
0 vote379 views1 answer
Add sqlcmd to path linux
SQL
0 vote347 views1 answer
Plpgsql coalesce equivalent for empty string
SQL