hi,
what u want to achieve from this type clause? Group by we r doing
for group functions like sum, avg..
I think u want common data of Column1. Then u can use DISTINCT clause of
Criteria like Criteria.DISTINCT
Santosh
> -----Original Message-----
> From: Vidakovic Aleksandar [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, July 06, 2001 11:34 AM
> To: [EMAIL PROTECTED]
> Subject: Group By with Criteria
>
> Salut folks,
>
> I'm desparately trying to create a Query like "SELECT COLUMN1 FROM
> TABLE1 GROUP BY COLUMN1" with Turbine's Criteria class.
>
> 1. How do I add the "GROUP BY" clause?
> 2. Why am I getting following Exception from village:
> com.workingdogs.village.DataSetException: Only 1 columns exist!
>
> Am I missing something here???
>
> Thanks in advance,
>
> Aleks
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
