Re: LIMIT, ORDER Dilema

[Paul DuBois]

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.