<p>I have a table with game scores, allowing multiple rows per account id: <code>scores (id, score, accountid)</code>. I want a list of the top 10 scorer ids and their scores.</p>

<p>Can you provide an sql statement to select the top 10 scores, but only one score per account id? </p>

<p>Thanks!</p>

Try this:
```
```
select top 10 username, 
              max(score) 
from usertable 
group by username 
order by max(score) desc
```
```