Thanks, Vasily.
I think your OJB code may return different results
from the SQL statement. Your OJB code will return a
number for each people group. But by the SQL statement
, we can only get a number, the count of groups.
Anyway, you gave me a great suggestion. Thanks again,
Bin
--- Vasily Ivanov <[EMAIL PROTECTED]> wrote:
> Sorry,
>
> Read this:
> subQuery.addGroupBy(new String[] { "lastname, age,
> city" });
> as this:
> query.addGroupBy(new String[] { "lastname, age,
> city" });
>
> Cheers,
> Vasily
>
> On 8/9/06, Vasily Ivanov <[EMAIL PROTECTED]> wrote:
> > 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]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
