Re: Intermedia Catalog Indexing

From: Jusung Yang <jusungyang_at_yahoo.com>
Date: 8 Aug 2002 14:23:21 -0700
Message-ID: <42ffa8fa.0208081323.dc47233_at_posting.google.com>

Right. Rank and Dense_rank can be used to control rows returned, of course. Though they are more geared towards controlling "what" is returned as oppsed to "how much". With ranking, extra work will be needed to ask ORACLE to return a precise number of rows - if you have multiple rows in each rank. ROWNUM is of course more convinient if you are not concerned with the ranking of the data and just want to limit the amount of rows returned.

<timkarnold_at_comcast.net> wrote in message news:<k8t49.51426$6Z1.1949204_at_bin6.nnrp.aus1.giganews.com>...
> "Jusung Yang" <jusungyang_at_yahoo.com> wrote in message
> news:42ffa8fa.0208071943.4dc4255_at_posting.google.com...
> > Thanks for the link. Not sure analytical functions can be used to
> > limit rows returned though.
>
> I've used dense rank to get the top N for example.
>
> http://asktom.oracle.com/pls/ask/f?p=4950:8:1142099::NO::F4950_P8_DISPLAYID,
> F4950_P8_CRITERIA:750625651018,%7Btop%7D%20and%20%7Bn%7D
Received on Thu Aug 08 2002 - 23:23:21 CEST

This message: [ Message body ]
Next message: John Brown: "Re: returning default printer name (full printer name) to a field in ORACLE FORMS(6i)"
Previous message: Lamont Norman: "Help! Pro*C ORACLIENT8.DLL Access Violation"
Maybe in reply to: Richard: "Intermedia Catalog Indexing"
In reply to timkarnold_at_comcast.net: "Re: Intermedia Catalog Indexing"
Next in thread: John Brown: "Re: returning default printer name (full printer name) to a field in ORACLE FORMS(6i)"

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

Original text of this message