Re: How to select rows in the middle.

Hi Alex,
I tested this to get rows between 5 and 12:

(select rownum,ename from emp where rownum <12) minus
(select rownum,ename from emp where rownum <5 )

Alex Peng wrote in message <6vej8i$7aq$1_at_earth.superlink.net>...
>I can use rownum to get first couple rows, but I don't know how to get
>rows like between 1000 and 2000.
>Can anyone tell me how ?
>
>Thanks,
>
>Alex
>
>
>
Received on Wed Oct 07 1998 - 03:22:50 CDT