Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Baron Schwartz (baronxaprb.com)
Date: Thu Oct 04 2007 - 05:15:02 CDT
Miroslav Monkevic wrote:
> 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.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql