SUM at the end of a select

[clarissa1996]

I need to compute the sum of a column at the end of a select statement.
How is this possible ?

Thanks. Clarissa

 

[swampBoogie]

You have to do that by summing in your application.

 

[r937]

or use a UNION, if you have mysql 4

[tt] select "detail"
, foo
, bar
from yourTable
union all
select "total"
, sum(foo)
, sum(bar)
from yourTable
order by 1[/tt]

nice that the word "detail" sorts before the word "total"


rudy

http://rudy.ca/