Hopefully someone can help with this.

To get to the heart of the problem I'll use a greatly simplfied example.
Let's say I have a table with two fields: city|member

There are, of course, many members in each city. What I'd lke to do is a *single* SELECT statement that pulls only 5 or less members for all DISTINCT cities in the table.

Thanks
Saiko