Re: pulling out a subset of records

2015-10-25 Thread John English
On 20/10/2015 11:23, Bob M wrote: I need to work out the following:- (2) the sum of the contents of that field in those records This is really quite elementary stuff. Like Marco says, you should read an SQL tutorial. The general form of the query should be: SELECT SUM(x) FROM y WHERE z>=0

Re: pulling out a subset of records

2015-10-20 Thread Bob M
ve) (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 li

Re: pulling out a subset of records

2015-10-20 Thread Bob M
Many thanks Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/pulling-out-a-subset-of-records-tp144942p144948.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: pulling out a subset of records

2015-10-20 Thread Marco Ferretti
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 fr

Re: pulling out a subset of records

2015-10-20 Thread Bob M
3 = rs.getInt(1); myConsole.getOut().println("Number of records in subset of table USDJPY_S where P/L >= 0: " + recordCount3); Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/pulling-out-a-subset-of-records-tp144942p144953.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: pulling out a subset of records

2015-10-19 Thread Bob M
Hi My exposure to derby so far has only involved creating a database, adding records or deleting a record. I have not extracted a subset which which to further process Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/pulling-out-a-subset-of-records

Re: pulling out a subset of records

2015-10-19 Thread Marco Ferretti
/2015 07:25, "Bob M" <rgmatth...@orcon.net.nz> ha scritto: > yes- correct > > Bob M > > > > -- > View this message in context: > http://apache-database.10148.n7.nabble.com/pulling-out-a-subset-of-records-tp144942p144946.html > Sent from the Apache Derby Users mailing list archive at Nabble.com. >

pulling out a subset of records

2015-10-19 Thread Bob M
with this code much appreciated Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/pulling-out-a-subset-of-records-tp144942.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: pulling out a subset of records

2015-10-19 Thread Marco Ferretti
ted > > Bob M > > > > -- > View this message in context: > http://apache-database.10148.n7.nabble.com/pulling-out-a-subset-of-records-tp144942.html > Sent from the Apache Derby Users mailing list archive at Nabble.com. >

Re: pulling out a subset of records

2015-10-19 Thread Marco Ferretti
to derby so far has only involved creating a database, adding > records or deleting a record. > > I have not extracted a subset which which to further process > > Bob M > > > > -- > View this message in context: > http://apache-database.10148.n7.nabble.com/pulling-out-a-sub

Re: pulling out a subset of records

2015-10-19 Thread Bob M
yes- correct Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/pulling-out-a-subset-of-records-tp144942p144946.html Sent from the Apache Derby Users mailing list archive at Nabble.com.