Re: Is it possible to get a subset of a result set?

How fast would the mySQL query listed below perform? The query isn't useful to me if it isn't very fast (several seconds).

Frank Rust wrote:

> Steven Hill (java410_at_yahoo.com) wrote:
> : If an _ordered_ query produces a result set of 10,000 rows, for
> : example, is possible to retrieve a subset, say, rows 2500 to 3000
> : without reading through the first 2499 rows of the result set?
>
> : In Oracle, I'd like to use:
>
> : select * from employee
> : where rownum >= 2500 and rownum <=3000
> : order by lastname
>
> I can't tell for Oracle, but in mySQL I woul do a
> select * from employee
> order by latname
> limit by 2500,500
>
> Frank

--
Steven Hill,
Computer Catalyst, Inc.
Toronto, Canada

(please take out 'remove' from my address when sending an email) Received on Thu Sep 23 1999 - 11:47:45 CDT