-
Selecting A Limited Number of Results By a Distinct Value
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|