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

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 Received on Thu Sep 23 1999 - 08:13:57 CDT