Hi there,

Suppose I have like 100 records sorted on a unique ID. How can I select, for example, records 30 to 40 from this set? Note: the ID values are NOT in one range though. They could be, for example, 1,2,5,6,7 etc.

U may add a column to hold sequence's running values(it has continuous values) & wrt this column u may specify the range.

(while using rownum ,it only refer from beginning of the table ie from first row itself.)

Hope it works.

Oracle 9i,

Select columns
from
(select columns, RANK() OVER (ORDER BY column) RN from table) V
where V.RN BETWEEN X AND Y;

In almost any SQL dialect, you can use:...but that is a really poor use of the SQL engine. You are really better off to retrieve the whole set, then filter out the rows that interest you on the client.

-PatP