Re: How to select rows in a given range?

select * from

    ( select rownum r, a.* from tableA a ) where r between 100 and 150;

"Emre Akbag" <akbag_at_scr.siemens.com> wrote in message news:D3NA5.5664$l35.134624_at_iad-read.news.verio.net...
> How can I select rows from a table in a given range?
>
> I can restrict maximum number of rows fetched using "rownum", like :
>
> select * from tableA where rownum < 100;
>
> But, as documented in Tech.net too, "rownum" doesn't work with "between"
 or
> ">" operators.
> That's why, following queries DON'T work:
>
> select * from tableA where rownum > 100 ;
> OR
> select * from tableA where rownum BETWEEN 100 AND 150;
>
> How can I realise this? I'd appreciate any ideas.
>
> --
> Thanks in advance
>
> Emre AKBAG
>
> akbag_at_scr.siemens.com
> Siemens Corporate Research
>
>
Received on Thu Sep 28 2000 - 14:50:58 CDT