Removing NEAR duplicate results

I have a database of runners times on each course. I also have the
year they ran that time and their age that year. I am trying to make a
top 10 list for each age and a top 10 list for all runners on a
particular course.
The problem I am running into is that a runner may have had multiple
times on a certain course that are on the top 10 list. I only want
that particular runners' top time

For intance a top 10 result now may read

Matt 2006 16:56
Joe 2007 7:00
Matt 2005 17:11
Matt 2006 17:16
Matt 2007 17:24
Joe 2005 17:25
Fred 2006 17:34

etc...

I want it ot just return
Matt 2006 16:56
Joe 2007 17:00
Fred 2006 17:34

and then fill in the rest of the top 10


Obviously the only portion that is a duplicate is the name and course.
The year may or may not be different. The times will be different. The
age may or may not be different.


any ideas?


-Ryan Sharp

.

Relevant Pages

  • Re: Removing NEAR duplicate results
    ... Your example doesn't show age. ... that particular runners' top time ... Matt 2006 16:56 ... Joe 2007 7:00 ...
    (microsoft.public.access.queries)
  • Re: Removing NEAR duplicate results
    ... Your example doesn't show age. ... that particular runners' top time ... Joe 2007 7:00 ... Matt 2005 17:11 ...
    (microsoft.public.access.queries)
  • Re: Running can help slow the ageing process.
    ... Both groups became more disabled with age, but for the runners the onset ... of disability started later - an average of 16 years later. ... anyone with a health problem that would ...
    (uk.rec.cycling)
  • Re: Another Brain Dead Bimbo Joins The Cast.
    ... Will the companion be in awe of the doctor, ... our relationship to knowledge and wisdom. ... What age do real doctors qualify to start practicing? ... Isn't that about the same age that Matt Smith is now? ...
    (rec.arts.drwho)
  • Re: NYC Marathon & Lance
    ... Lots of runners perform better at 30 than they ... "BMI in middle age partially determined by ... field 10K can produce 25 yr old winners and 35 yr old winners. ...
    (rec.running)