Xref: alice comp.databases.oracle.server:24150 Path: alice!news-feed.fnsi.net!news.idt.net!howland.erols.net!dca1-hub1.news.digex.net!digex!newsreader.digex.net!not-for-mail From: "Carlos Orozco" Newsgroups: comp.databases.oracle.server References: <35498729.29C9@comp.polyu.edu.hk> Subject: Re: ROWNUM problem... Lines: 18 X-Newsreader: Microsoft Outlook Express 4.72.2106.4 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Message-ID: Date: Tue, 07 Jul 1998 13:46:22 GMT NNTP-Posting-Date: Tue, 07 Jul 1998 09:46:22 EDT Organization: DIGEX, Inc. - Beltsville, MD - http://www.digex.net 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@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