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
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
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.
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
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.
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
/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.
>
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.
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.
>
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
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.
11 matches
Mail list logo