 | | | LIMIT within GROUP BY | LIMIT within GROUP BY 2007-10-04 - By Peter Brawley
Back
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!
>
>
|
|
|