Distinct???

[J-F]

I have an SQLServer DB which contains times for competitors who have taken part in standard distance running events. Some competitors have taken part in these events more than once. How can I show their best result without showing any of their subsequent results.

J-F

 

[Nouba]

try a query like

SELECT
  competitor
, Min(result) AS BestResult
FROM tblCompetitor
GROUP BY competitor

HTH Nouba