Date: Mon, 12 Feb 2007 10:59:18 -0500
From: Sylvain Barrette <sylvain@remax-quebec.com>
Subject: RE : Sum sets of records
In-reply-to: <55c095e90702120741w3908f730vbd23b6d9b4fa7cc3@mail.gmail.com>
To: 'Ezequias Rodrigues da Rocha' <ezequias.rocha@gmail.com>,
	pgsql-sql@postgresql.org
Message-id: <00c301c74ebe$c094abb0$1e01a8c0@fdpr.com>
MIME-version: 1.0
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: quoted-printable
Importance: Normal

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=3D'C' then value when type=3D'W' then -value =
else
0 end) from MyTable

hth


Sylvain Barrette
Architecte et  analyste principal,
RE/MAX Qu=E9bec 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

--=20
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
=20