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 votes186 views2 answers
How to open postgresql in windows
SQL
0 vote180 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote143 views1 answer
Store query result in variable sql
SQL
2 votes164 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote180 views1 answer
Possgress drop if exists view
SQL
39 votes195 views4 answers
Select duplicates in sql
SQL
0 vote204 views1 answer
Min:sec datediff mssql
SQL
7 votes161 views2 answers
Create mysql user
SQL
0 vote188 views1 answer
Postgres create extension if not exists
SQL
0 vote202 views2 answers
Coursera spark sql max count
SQL