Re: Q: returning rows between two positions in a large query

From: <shiling_at_math.wayne.edu>
Date: Tue, 22 Jun 1999 13:45:04 GMT
Message-ID: <7ko40t$959$1@nnrp1.deja.com>

The following example selects records between #3-#4.

SQL> select * from t
  2 ;

TDATE

---

09-JAN-99
09-JAN-98
09-JAN-97
09-JAN-96
09-JAN-95
09-JAN-94

6 rows selected.

SQL> select * from t where rownum<=4
  2 minus
  3 select * from t where rownum<=2;

TDATE

---

09-JAN-96
09-JAN-97 SQL> Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 22 1999 - 08:45:04 CDT