Re: [SQL] Limit rows

Hello,

On Wed, 29 Sep 1999, Oleg Bartunov wrote:

> select * from table  limit 5,10;

Excellent, that works perfectly. I've done a grep over the html
documentation, and can't see anything regarding the limit feature (if I've
just missed it and it is there could someone provide a pointer please?).

I'm interested now in how this method actually works - is a query
performed that reads all of the rows of a table into memory, and then the
non-requested rows are discarded before the results are sent back?

I'm interested in how this would work with a massive table......

Regards,

Mark.
-- 
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com