db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bob M <rgmatth...@orcon.net.nz>
Subject Re: pulling out a subset of records
Date Tue, 20 Oct 2015 08:23:12 GMT
Just to finish....................

I need to work out the following:-
(1) no. records in the subset where another field's value  is >=0
(2) the sum of the contents of that field in those records

(3) no. records in the subset where the value of the same field above is < 0
(i.e. negative)
(4) the sum of the contents of that field in those records

I can code (1) and (3) but how to do (2) & (4) ?

Bob M



--
View this message in context: http://apache-database.10148.n7.nabble.com/pulling-out-a-subset-of-records-tp144942p144949.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Mime
View raw message