rownum is a pseudo column, the values are assigned after the data is
retrieved. You can use the having clause to get at this portion.
Jimmy wrote in message <35498729.29C9_at_comp.polyu.edu.hk>...
>Hello all,
>
> When I type "select A from AAA" then 100 rows selected.
> Now, I want to select the first 10 records. So I type "select A from
>AAA where rownum > 0 and rownum <= 10", then 10 rows selected.
> Now, I want to select the NEXT 10 record by "select A from AAA where
>rownum > 10 and rownum <= 20", then no row selected.
>
> Could anyone tell me why no row selected? And how to select the NEXT 10
>records by a SQL statement?
>
>Thanks,
>Jimmy
Received on Tue Jul 07 1998 - 08:46:22 CDT
