Re: Count a Subquery with group clause

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]
> 
>