SELECT customer ,section ,[count] FROM (SELECT customer ,section ,[count] ,ROW_NUMBER() OVER (PARTITION BY customer ORDER BY count DESC ) AS rn FROM #e ) tmp WHERE rn <= 3

https://stackoverflow.com/questions/16720525/how-to-select-top-3-values-from-each-group-in-a-table-with-sql-which-have-duplic

than put the 3 top rows into one column SELECT customer ,STUFF((SELECT ',' + c2.section FROM #c AS c2 WHERE c.customer = c2.customer FOR XML PATH ('')) , 1, 1, '') FROM #c AS c GROUP BY customer 20.11.19

https://sqlandme.com/2011/04/27/tsql-concatenate-rows-using-for-xml-path/

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024