Re: how can i select top 100 with a sql statement in oracle
From: Tom Grenier <tom_at_sqlman.com>
Date: Tue, 19 Feb 2002 07:12:53 -0800
Message-ID: <3C726B75.2CA1FEC1_at_sqlman.com>
Date: Tue, 19 Feb 2002 07:12:53 -0800
Message-ID: <3C726B75.2CA1FEC1_at_sqlman.com>
What is 'top' and what is 'whatever'? These terms are pretty meaningless in SQL. If you just want 100 rows returned -- add WHERE rownum < 101
Leader wrote:
> Hi all,
> I need a sql statement which will select top 100 or whatever from table.
> please reply me asap
>
> thanks
> hoque
Received on Tue Feb 19 2002 - 16:12:53 CET