Better way to select a block of rows

Hi anybody,

I want to read the rows inside a generic table T between j and k (with j<k).
For this operation I'm using the select statement:

SELECT * FROM T WHERE rownum <=k
MINUS
SELECT * FROM T WHERE rownum <=j;

My question is: there is a faster way to perform this operation?

Thanks in advance
SbaizP. Received on Tue Jun 22 1999 - 07:18:28 CDT