Fetch one row per account id from list

Question

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

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

Thanks!

Answer 1

select username, max(score) from usertable group by username order by max(score) desc limit 10;