Re: LIMIT within GROUP BY

## Baron Schwartz wrote: Change the > to >= and the < to <= to deal with this. Baron Miroslav Monkevic wrote: Thanks Baron, great advice (as always). My real query is a bit more complicated but speaking in terms of example I provided, I took this path: ##

Re: LIMIT within GROUP BY

aven't found any solution yet. Baron Schwartz wrote: Hi, 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:

LIMIT within GROUP BY

y. 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]