Pete-600513 (1/19/2013)
Thank you very much. I thought there might be an easy way with the max function
You were right.
SELECT DT.max_score, A.name, a.dob
FROM dbo.Exam A
INNER JOIN (SELECT MAX(score) max_score
FROM dbo.Exam
) DT ON DT.max_score = A.score
_____________
Code for TallyGenerator