Re: easy question

From: Aleksandr Kononov <AKononov_at_pptk.energo.ru>
Date: Fri, 25 Aug 2000 06:27:58 GMT
Message-ID: <8o53ku$lvd$1@nnrp1.deja.com>

Hi,

select

....
from

....
where

rownum <= 6
;

Regards,
Aleksandr Kononov

In article <d4kp5.110249$c5.2436817_at_news2.rdc1.on.home.com>, "Marshall Mednick" <marshall.mednick_at_utoronto.ca> wrote:
> Hi there,
>
> I would like to select only the top 5 rows of a select statement,
however
> using the keyword TOP doesn't seem to work. What might the syntax be
for an
> oracle 8.0.4 database?
> I've tried SELECT TOP 5 Grading from Grading;
>
> Thanks inadvance.
> Marshall.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Aug 25 2000 - 01:27:58 CDT