summing the sum in mysql

Posted by JPro on Stack Overflow See other posts from Stack Overflow or by JPro
Published on 2010-05-25T12:43:41Z Indexed on 2010/05/25 12:51 UTC
Read the original article Hit count: 127

Filed under:

Hi,

Say If I get a resultset in mysql as :

ID  count(posts)
101 2344
102 3245
103 232
104 23

Is there any way to get the tota count of count(posts) in the query itself, like this?

ID  count(posts)
101 2344
102 3245
103 232
104 23
   ------
    5844

© Stack Overflow or respective owner

Related posts about mysql