Ok so I have this issue I can not get resolved.
There is a list of statistics on a table. They are then grouped by a
category number (1 through 10). I want to select only the max record for
each
category on the table, but only if it is unique and not a tie.
For instance category 1 has 5 records, 55,56,57,58,59. The query would
select 59 (obvious and easy). However, lets say category 2 has 5 records
55,56,57,58, and 58, I want the query to return NOTHING for category 2.
If someone could please help me with this, it would be much appreciated =)
|
