Re: Rownum

From: Roger Jackson <rjackson_at_wire.net.au>
Date: 2000/06/14
Message-ID: <8i7ojk$vlq$1@news1.wire.net.au>#1/1

Naguib,

Have you considered using the "having" clause?

Cheers,

Roger.

"Naguib Younes" <ynaguib_at_videotron.ca> wrote in message news:D3B15.3261$D5.101655_at_wagner.videotron.net...
> Hi,
>
> Does anybody know how to return just a small set of data, ex record 20 to
30
> in a record set, in a select statement, i used rownum, but i soon as you
do
> an order by, it stops working, i used hints, but it stop working when the
> SQL become complicated, i'm out of ideas how to fixe this,
>
> Any help will be appreciated,
>
> Thanks in advance
>
> NY
>
>
Received on Wed Jun 14 2000 - 00:00:00 CDT