LIMIT within GROUP BY

[Miroslav Monkevic]

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!


--
Best regards,
Miroslav Monkevic


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]