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 22:27:04 -0800
Message-ID: <3C7341B8.3ADCFE1C_at_sqlman.com>
Date: Tue, 19 Feb 2002 22:27:04 -0800
Message-ID: <3C7341B8.3ADCFE1C_at_sqlman.com>
After coming from years with Informix (which I still like -- even if dead) it just amazes me the depth of Oracle. There is a TOP command -- I've read the asktom article on RANK -- thanks for pointing that direction.
I'm still waiting to find out what a WHATEVER command does ;-)
Tom
Bricklen wrote:
> use the RANK or DENSE_RANK functions for top N queries. (8.1.6 and up).
> Go to http://asktom.oracle.com and look for those (or analytic
> functions), or search http://tahiti.oracle.com for the syntax.
>
> 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 Wed Feb 20 2002 - 07:27:04 CET