mysql sum values from query

Question

The mysql query looks like:

SELECT count(f.id) as total, m1.fname FROM members m1 INNER JOIN new f ON m1.id = f.id

The result of that query:

   total | fname  | 
  ------------------
    2    |  john
    3    |  mike
    5    |  july

How can I sum values from column "total" using this mysql query?

I want to sum values from column "total", not the values of ID's — Sergio
– Sergio, Commented Jun 2, 2011 at 15:00
Just an observation : using ids for semantic meaning of your model it could not be the best idea to model things. Id should be only used for persistence of models — llazzaro
– llazzaro, Commented Jun 9, 2011 at 15:33

Xint0 · Accepted Answer · 2011-06-02 15:02:42Z

2

Use SUM on the subquery:

SELECT SUM(c.total) AS total_sum
FROM (
    SELECT count(f.id) as total, m1.fname
    FROM
        members m1 INNER JOIN
        new f ON m1.id = f.id
) AS c

answered Jun 2, 2011 at 15:02

Xint0

5,4192 gold badges30 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

llazzaro · Accepted Answer · 2011-06-02 15:05:28Z

0

You should use sum() instead of count(). did you check sum?

SELECT sum(f.id) as total, m1.fname FROM members m1 INNER JOIN new f ON m1.id = f.id

edited Jun 2, 2011 at 15:05

answered Jun 2, 2011 at 14:56

llazzaro

4,2184 gold badges35 silver badges47 bronze badges

2 Comments

Sergio Over a year ago

in that case I get sum od "id" values, not values from "total" column

llazzaro Over a year ago

sorry I understand you want to sum ids.

Collectives™ on Stack Overflow

mysql sum values from query

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related