sql server mseq: Is it possible to retreive the Top n columns for each
distinct value in the Group By?
Example Table has Divisions, Customers and Invoices.
I want to return the Top 10 Customers for each Division
based on the Sum(Invoices).
NOTE, I'm trying to do this with Data Warehouse data so

[quoted text, click to view]

Hi Khris,

Try if this helps:

SELECT a.Division, a.Customer, SUM(a.Invoices)
FROM YourTable AS a
WHERE a.Customer IN (SELECT TOP 10 b.Customer
FROM YourTable AS b
WHERE b.Division = a.Division
GROUP BY b.Customer
ORDER BY SUM(b.Invoices))
GROUP BY a.Division, a.Customer

Best, Hugo
--