RE : Sum sets of records

Hi,

"Group by" is what you're looking for..

select type,sum(value) from MyTable group by type

Or for the total only

Select sum(case when type='C' then value when type='W' then -value else
0 end) from MyTable

hth


Sylvain Barrette
Architecte et  analyste principal,
RE/MAX Québec inc.


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

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.411 / Virus Database: 268.17.36/681 - Release Date:
2007-02-11