Re: Get first 10 records?

From: Wolfgang Zilgens <wzilgens_at_consem.de>
Date: Wed, 17 Oct 2001 16:33:04 +0200
Message-ID: <9qk4sk$o8dva$1@ID-92001.news.dfncis.de>

select ...
from ...
where ...

and ROWNUM < 11

"harry" <a_at_abc.com> schrieb im Newsbeitrag news:g95rstsql127pjftt992bqbnoi70nt8b76_at_4ax.com...
> Using Oracle 8i 8.1.7
>
> Is it possible to return just the first say 10 records from a select
statment?
>
> thanks
>
> harry
Received on Wed Oct 17 2001 - 09:33:04 CDT