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

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

Unfortunately, the order by clause is done after the row range is retrieved. Ideally, I'd like the solution to use a single select statement and not Java or PL/SQL code. Is this possible?

--
Steven Hill Received on Mon Sep 20 1999 - 11:48:23 CDT