CODEWITHSUNDEEP
sqlnetezza
Chad Johnson
Chad Johnson

Reputation: 65

SQL Netezza Column to List

Seeking assistance for a way to create the Result set below in a single SQL statement. Thanks!

enter image description here

enter image description here

Upvotes: 1

Views: 3054

Answers (1)

Chad Johnson
Chad Johnson

Reputation: 65

SELECT a.AC9, 
   MAX(CASE a.RNO WHEN 1 THEN a.value ELSE '' END) || 
   MAX(CASE a.RNO WHEN 2 THEN ', '||a.value ELSE '' END) 
FROM (SELECT AC9, value, ROW_NUMBER() OVER (PARTITION BY AC9 ORDER BY value) RNO FROM table) a 
GROUP BY a.AC9

Upvotes: 1

Related Questions