Re: to sqlplus expert. - is this sqlplus version problem?

On 2005-10-14, jdyang <jdyang82_at_gmail.com> wrote:
> Hello. I'm newbie of sqlplus.
>
> I use sql plus 8.1.5.0.0.
>
> I want to get row between 3 to 5. like,
>
> select * from table where rownum >= 3 and rownum =< 5;
>
> and when I use above query, there is no record.
>
> I found reason from google that rownum is attached to row when that row
> pass the where condition.
> And from another webpage, I found the message that those query are
> working well.
>
> how I can get row between 3 to 5. Above query is just version problem?
>
> Infact, I'm using temporary query:
> select * from
> ( select <column names>, rownum as temp_rownum where <table> )
> where temp_rownum >= 3 and temp_rownum <=5;
>
>
> and surely, I'm not satisfied.
>
> Can you help me please? - to sql experts.

See http://www.adp-gmbh.ch/ora/sql/examples/first_rows.html

hth, Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/