Re: SELECTing N rows

If the query has no order by clause or group by clause you could do it with the pseudo column rownum, that reference each row number in the results of a query.

Lan H. Tran wrote:

> could someone help me write a query that will
> 1. return rows 1 - 100 from a table,
> 2. return rows 101 - 200 from a table,
> 3. etc..
>
> please reply to my e-mail as well as this group. thanks in advance.
>
> Lan
>
> ------------------------------------------------------------------------
>
> Lan Tran <ltran_at_netscape.com>
> Consultant
> Netscape Communications
>
> Lan Tran
> Consultant <ltran_at_netscape.com>
> Netscape Communications HTML Mail
> Work: 301-571-3924
> Home: 703-256-2413
> Netscape Conference Address
> Netscape Conference DLS Server
> Additional Information:
> Last Name Tran
> First Name Lan
> Version 2.1
Received on Sun Aug 16 1998 - 12:23:21 CEST