Is there a query for this case? [message #371749] |
Fri, 01 December 2000 12:48 |
John Armani
Messages: 3 Registered: December 2000
|
Junior Member |
|
|
Say I have a table with the following data:
Id Grade
-- -----
1 A
2 B
3 C
4 A
5 B
6 A
7 D
I would like a query to return all id/grade combinations where there are multiple ids with the
same grade (and order by Grade). The query would return the following from the above table...
Id Grade
-- -----
1 A
4 A
6 A
2 B
5 B
Is it possible through a single query? Any clues would be greatly appreciated.
John
armani@armani.rochny.uspra.abb.com
|
|
|
|
|
|
|