Hi Marco
Am I getting any closer :)
rs = s.executeQuery("SELECT Class1_predicted, Class2_predicted,
Class3_predicted, Class4_predicted, Class5_predicted, Class6_predicted,
Class7_predicted, Class_predicted,"
+ "aggregate_function (SUM (PROFIT_LOSS)) "
+ "FROM USD_JPY_S "
+ "WHERE CLASS1_PREDICTED = class1_predicted, CLASS2_PREDICTED =
class2_predicted, CLASS3_PREDICTED = class3_predicted, CLASS4_PREDICTED =
class4_predicted,"
+ "WHERE CLASS5_PREDICTED = class5_predicted, CLASS6_PREDICTED =
class6_predicted, CLASS7_PREDICTED = class7_predicted, CLASS_PREDICTED =
class_predicted,"
+ "PROFIT_LOSS >= 0,"
+ "GROUP BY Class1_predicted, Class2_predicted, Class3_predicted,
Class4_predicted, Class5_predicted, Class6_predicted, Class7_predicted,
Class_predicted");
rs.next();
int recordCount3 = 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.
