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

"jdyang" <jdyang82_at_gmail.com> wrote in
news:1129299491.669160.193880_at_g49g2000cwa.googlegroups.com:

> 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.
>
>

You can't get there from here.
You'll NEVER get any row when using WHERE ROWNUM >= 3 You are using the wrong tool for the job. Stop using ROWNUM Received on Fri Oct 14 2005 - 09:37:44 CDT