select max of sum

[Anon]

hi,

how do i construct a mysql query which will return the MAX value of a series of SUMs?

thanks

will.

[crislewis]

Try the simple approach:

SELECT sum(field) AS total ORDER BY total DESC LIMIT 1

This will place the highest sum in the first row of the result.

Remove the LIMIT 1 if you want to work through the rows top down. Note that you will need to do this to handle multiple top scores.

Cheers,

Cris