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