ROWNUM problem...

From: Jimmy <c6635500_at_comp.polyu.edu.hk>
Date: Fri, 01 May 1998 01:26:17 -0700
Message-ID: <35498729.29C9@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 Fri May 01 1998 - 03:26:17 CDT