db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject Re: Select Where Max
Date Thu, 06 Jul 2006 06:59:51 GMT
Hi,

have you tried the following:

Criteria criteria = new Criteria();
criteria.add(GalleryPeer.VIEWS, "max(" + GalleryPeer.VIEWS + ")");
List result =GalleryPeer.doSelect(criteria);


    Thomas

"Trevor Miller" <web1p3@fox5.co.za> schrieb am 06.07.2006 07:46:13:

> Hi All,
>
> I have been scratching my head trying to figure out how to do the
following:
>
> "SELECT * FROM gallery WHERE views=MAX(views);"
>
> In other words, I want to find the gallery with the most views.
>
> Any suggestions on how to achieve this with Torque 3.2 and MySQL would be
> greatly appreciated.
>
> Regards,
> Trevor
>
>
>
> ---------------------------------------------------------------------
> 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