Re: LIMIT within GROUP BY

[Peter Brawley]

Miroslav

>My goal is to sum 7 greatest results for each person.
Have a look at 'Within-group quotas (Top N per group)' at 
http://www.artfulsoftware.com/infotree/queries.php.

PB

-----

Miroslav Monkevic wrote:
Hello,

MySQL 4.1

I have query:
SELECT SUM(points) as ranking FROM results GROUP BY person_id ORDER BY 
ranking DESC

My goal is to sum 7 greatest results for each person.

In more general, my question is: is there a way to limit number of 
records within  groups in  "group by" query.

Thank you!