Thanks everyone,
Gave me some ideas of what to search and found a solution by searching to break ties.
Gave me the answer,
Code now looks like this -
SELECT t.AthleteID, t.AthleteName, t.Gender, t.AgeGroup, t.ClubID, t.ClubCategory, t.EventID, t.UniquePerfID, t.Score
FROM [T05 All Throws...