At 11:32 -0800 3/30/02, destr0 wrote: >Can you not have the LIMIT clause before the ORDER Clause in a select query? > >SELECT * FROM myTable LIMIT 30, 45 ORDER BY someField ASC; > >This query ^ fails with the error: > >Error 1064: You have an error in your SQL syntax near ' ORDER BY someField >ASC' at line 1 > >I just want to make sure that the case is that you can't have your LIMIT >clause before your order clause.
You can't. And even if you could, the ORDER BY would be evaluated before the LIMIT. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
