db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Trevor Miller" <web...@fox5.co.za>
Subject Select Where Max
Date Thu, 06 Jul 2006 05:46:13 GMT
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.


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

View raw message