Re: How to use ROWNUM

Vincent Chen wrote:
>
> Dear all
>
> I have a very large table.
> And the content in this table will be display in Web page.
> (using ADO + ODBC)
>
> Since the size of table is too big, I wish to display all tuples page by
> page.
> I found 'rownum' command in oracle document.
> however, the following command is not worked.
>
> select ...
> from ...
> where rownum between 100 and 200;
>
> this command return no rows ....
>
> can somebody help me ....

select *
from ( select rownum rnum, a.* from table a where rownum < 200) where rnum > 100

but it would be far more practical to have some sort of sequencing column on your rows - given that there is no guarantee that rownum gives your the rows in a pre-ordained sequence.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse