What would be the best way to do this in a SELECT statment?
I have a table with scores. Each person may have more than one score but I need to select only the highest for EACH person.

I am not sure how to do it in a subquery. I tried something like this but of course is not good:
SELECT * FROM myCur WHERE id = id;
AND score IN ;
(SELECT MAX(score) FROM myCur)

thanks in advance