How to retrieve sum of individual column

[shastry]

Hello there,
plz help me to comeout of this stuff..
I have table with the following fields..

1 2 3 4 5

user project pagesadded deleted total(3-4)

one DB1 10 5 5
two DB2 11 3 8
one DB1 19 8 11

two DB2 11 3 8

And what I wann is

user project pagesadded deleted total(3-4)

one DB1 29 16 13

two DB2 22 6 16

can any one help me how to do this stuff
Thanx in advance..

[Anon]

You'll need to use the SUM() and the GROUP BY statements.

i.e. select user, project, sum(pagesadded), sum(deleted), sum(total)
from tablename
group by user,project