Re: how can i select top 100 with a sql statement in oracle

From: Bricklen <bricklenREMOVETHIS_at_shaw.ca>
Date: Tue, 19 Feb 2002 15:13:52 GMT
Message-ID: <3C726B34.F6386026_at_shaw.ca>

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 Tue Feb 19 2002 - 16:13:52 CET

This message: [ Message body ]
Next message: Mechanical Mann: "Re: PL/SQL Sample Questions"
Previous message: K Sudhakaran: "Re: Using Advance Replication for updating content from one server to the other..."
Next in thread: Tom Grenier: "Re: how can i select top 100 with a sql statement in oracle"
Reply: Tom Grenier: "Re: how can i select top 100 with a sql statement in oracle"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message