db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mansour Raad" <mr...@e-iit.com>
Subject RE: MIN, MAX, AVG etc.
Date Thu, 18 Sep 2003 22:57:48 GMT
Eric,

Did u ever figure out how to create a criteria with 'MIN' ? Any help is much
appreciated.   I followed the link below,  but it only refers to DISTINCT !

Mansour
:-)

-----Original Message-----
From: Eric Emminger [mailto:eric@ericemminger.com] 
Sent: Friday, September 12, 2003 12:59 PM
To: Apache Torque Users List
Subject: Re: MIN, MAX, AVG etc.


Jukka

Jukka Raanamo wrote:
> How do you get Torque to generate query like:
> 
> select distinct field1, min(field2) 
>                         ^^^^^^^^^^^
> from table
> group by field1

http://marc.theaimsgroup.com/?l=turbine-torque-user&m=105372021214290&w=2

Eric


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message