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]
