select sum(case when id = 'C' then value else -value end) as total
>>> "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com> 2007-02-12 16:41 >>>
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 ?
In response to
pgsql-sql by date
|Next:||From: Sylvain Barrette||Date: 2007-02-12 15:59:18|
|Subject: RE : Sum sets of records|
|Previous:||From: Ezequias Rodrigues da Rocha||Date: 2007-02-12 15:41:10|
|Subject: Sum sets of records|