Find the Maximum of the sum of some fields.

[ilmaggy]

Hi,

I want to select the biggest result which I get by adding the fields named "vote" with the same user_id.
I thought of the following (but it didn't work out, unfortunately):

SELECT max(sum(rating)) FROM votes WHERE user_id = $user_id

Could anyone help me with this?
Thanking you in advance,
Ruben.

 

[nego78]

maybe i'm wrong but try this

SELECT sum(rating) AS Maxsum FROM votes WHERE user_id = $user_id GROUP BY user_id ORDER BY Maxsum DESC LIMIT 1

gry online