select id, max(score) as maxsc from mycur into curs maxcur
SELECT myCur.* FROM myCur, maxsc WHERE ;
mycur.id=maxsc.id and mycur.score=maxsc.score
If someone would have two records with the result equal to their max, you'll get them both, unless we include GROUP BY mycur.ID in the second select.
There'd probably be someone who can do this in an one-liner, but I'm just too tired at this moment :)
back to same old
the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.