Path: news.easynews.com!easynews!feedwest.aleron.net!aleron.net!sfo2-feed1.news.algx.net!allegiance!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: jusungyang@yahoo.com (Jusung Yang) Newsgroups: comp.databases.oracle,comp.databases.oracle.tools Subject: Re: Intermedia Catalog Indexing Date: 8 Aug 2002 14:23:21 -0700 Organization: http://groups.google.com/ Lines: 19 Message-ID: <42ffa8fa.0208081323.dc47233@posting.google.com> References: <42ffa8fa.0208061214.6219bf15@posting.google.com> <42ffa8fa.0208071943.4dc4255@posting.google.com> NNTP-Posting-Host: 64.168.22.105 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1028841802 22297 127.0.0.1 (8 Aug 2002 21:23:22 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 8 Aug 2002 21:23:22 GMT Xref: easynews comp.databases.oracle:16850 comp.databases.oracle.tools:52913 X-Received-Date: Thu, 08 Aug 2002 14:20:27 MST (news.easynews.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. wrote in message news:... > "Jusung Yang" wrote in message > news:42ffa8fa.0208071943.4dc4255@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