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

Thanks for the reponse! But how do I handle the order by clause? My select will be sorted according to user input (ie dynamically), and it has to be sorted first, and then select rows from 150 to 199 etc.

TIA! On Tue, 22 Jun 1999 13:45:04 GMT, shiling_at_math.wayne.edu wrote:

>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 - 13:12:58 CDT