Re: select statement

From: helper <wangz_at_isd.net>
Date: Fri, 21 Jan 2000 23:42:58 GMT
Message-ID: <86aqtv$r3m$1@nnrp1.deja.com>

Do the following:

select a, b,c from (

           select a,b,c, rownum num from your_table)
     where num between 10 and 20;

good luck

Zosen

In article <866juq$2c268$1_at_fu-berlin.de>, "Kathinka Diehl" <kathinka_at_rrr.de> wrote:
>
> Vitek <victor_at_percombank.kiev.ua> schrieb:
> > select ...
> > where rownum<=10
>
> These are the first ten. Is there an easy possibility to get the next
ten?
>
> Tia
> Kathinka
>
>

--
Zosen Wang (wangz_at_rocketmail.com)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jan 21 2000 - 17:42:58 CST