Alastair, the LIMIT comes first. If you are in 7.6, you can return the
TOP so many, and this happens after the WHERE clause.
Alastair Burr wrote:
Hi,
I'm trying to edit the last n rows of a table using the (newish) LIMIT
option and it works just fine, of course.
My reading of the help file is that I cannot also use a WHERE clause.
Is this right or is there a way to reduce the rows returned still further?
If not I can easily create a temp table and work from that but if
there's an easier way...
Thanks in advance,
Regards,
Alastair
----------------------------
Alastair Burr
St. Albans, UK.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----------------------------
