P
Paid The Umpire
Some nice people gave me the following query to create a list of the
highest score in each of the Categorys overall for my sporting club.
SELECT *
FROM [Your Table] as A
WHERE A.Score =
(SELECT MAX(Score)
FROM [Your Table] as Tmp
WHERE Tmp.Category = A.Category)
I'm now trying to find a query like the above mentioned, except that I
now want to get the highest in each category, for each "Grade".
Any further ideas?
highest score in each of the Categorys overall for my sporting club.
SELECT *
FROM [Your Table] as A
WHERE A.Score =
(SELECT MAX(Score)
FROM [Your Table] as Tmp
WHERE Tmp.Category = A.Category)
I'm now trying to find a query like the above mentioned, except that I
now want to get the highest in each category, for each "Grade".
Any further ideas?