select sum(case when id = 'C' then value else -value end) as total
from mytable
>>> "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com> 2007-02-12 16:41 >>>
Hi list,
I would like a little help from you to get the sum value of various subsets of my table.
My table is like this
id | type | value
1 C 10.00
2 C 15.00
3 W 5.00
4 W 3.00
Where C is credit and w is witdraw.
How do I sum all records with C and subtract with all records with type W ?
Is it possible ?
Ezequias