MySql SUM() function

Question

Is it possible to use MySql SUM() function inside another MySql SUM() function ??

Like below

$query="SELECT SUM(Table1.Column1+SUM(Table2.Column2+Table2.Column3)) 
        from Table1 LEFT JOIN Table2 ON Table1.id = Table2.table1_id 
        WHERE Table1.Column2='Test'";

Thanks

Do you have an error?

sdespont
– sdespont

2014-02-18 07:58:39 +00:00
Commented Feb 18, 2014 at 7:58 — sdespont
– sdespont, Commented Feb 18, 2014 at 7:58
SELECT SUM(foo) + SUM(bar) as foobar ?

ponciste
– ponciste

2014-02-18 08:00:14 +00:00
Commented Feb 18, 2014 at 8:00 — ponciste
– ponciste, Commented Feb 18, 2014 at 8:00

xdazz · Accepted Answer · 2014-02-18 07:59:07Z

2

You just need one SUM():

SELECT SUM(Table1.Column1 + Table2.Column2 + Table2.Column3) ...

Or use SUM() on each field:

SELECT SUM(Table1.Column1) + SUM(Table2.Column2) + SUM(Table2.Column3) ...

answered Feb 18, 2014 at 7:59

xdazz

161k38 gold badges255 silver badges278 bronze badges

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

Comments

Dumitrescu Bogdan · Accepted Answer · 2014-02-18 08:00:03Z

0

From basic math a + b + c = a + (b + c)

So just use one sum. It will be equivalent with what you are doing there ..

answered Feb 18, 2014 at 8:00

Dumitrescu Bogdan

7,2652 gold badges26 silver badges32 bronze badges

Collectives™ on Stack Overflow

MySql SUM() function

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related