Hi Bin, Your query will not run because you can not put in GROUP BY without count(*) in SELECT clause of subquery. If you want to run this: ================= SELECT lastname, age, city, count(*) FROM people GROUP BY lastname, age, city ================= that you shoud do something like this in OJB: ================= ReportQueryByCriteria query = QueryFactory.newReportQuery(People.class, new Criteria()); query.setAttributes(new String[] { "lastname, age, city, count(*)" }); subQuery.addGroupBy(new String[] { "lastname, age, city" }); broker.getReportQueryIteratorByQuery(query); =================
Cheers, Vasily On 8/9/06, Bin Gao <[EMAIL PROTECTED]> wrote:
Hello All, How can I generate the following SQL statement using OJB? SELECT count(*) FROM ( SELECT lastname, age, city FROM people GROUP BY lastname, age, city ); Thanks for your help, Bin --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]