View Full Version : 1 name per score


sdkramer
03-22-2002, 02:21 PM
Quick question

I have the results of a query on two tables tblpeople and tblscores. I found the people who scored above a certain score. But since the same people take the same test over and over again. I have multiple references to the same people, because they have performed well multiple times. How can I make it so it only shows me those who succeeded, irrespective of how many times they have succeeded?

Pat Hartman
03-23-2002, 01:01 PM
Select PersonId, Max(TestScore) as MaxScore
From YourTable
Where TestScore > somevalue
Group By PersonId;