I have this statement that works perfectly fine in Access and MSSQL: (In words, i first get the top 50 id values according to the where clause and then i get the maximum of those id values)
"SELECT Max(id) FROM (select top 50 id from myTable where infoId in ( 3 ) AND id > 100 order by id ASC) AS t1 " (Note that id > 100 changes in every iteration of the loop in my code) I want to run a similar query in MYSQL....Is there *any* way to accomplish it ? I have tried the following query without any luck "SELECT Max(id) FROM (select id from myTable where infoId in ( 3 ) AND id > 100 order by id ASC LIMIT 50) AS t1 " Thanx in advance Best Regards Wajih -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
