Hi,

Is there an "easy" way (using 'group by' or similar) to get a count of records in a range from a table?

Example, suppose you have a simple table with one field for a customer number. Evey time the customer purchases something, they get a new entry in this table. Now it's easy to get a count for each customer of how many purchases they made, however - what if I want a "range count" - that is - a listing of how many customers made 1-5 purchases, how many made 6-10 purchases, 11-15, 16-20 and so on? Is there a way to wrap all this up in a single SQL statement?

thanks,
Ken