Select ranges of rows

Hi. I have a problem selecting a range of rows. What i want is to get the rows from X to Y in a specific order. I've found that:

 SELECT *

        FROM   tableX
        WHERE  rowid in (
           SELECT rowid FROM tableX
           WHERE rownum <= 7
          MINUS
           SELECT rowid FROM tableX
           WHERE rownum < 5);

It works, but it's hard to apply it to my query. Is there another way to do the same (with views or something else)?

thanks Received on Sun Feb 24 2002 - 17:13:07 CST