Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!64.245.249.51!sfo2-feed1.news.algx.net!allegiance!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!ihug.co.nz!border1.nntp.aus1.giganews.com!nntp.giganews.com!nntp3.aus1.giganews.com!bin6.nnrp.aus1.giganews.com.POSTED!not-for-mail Reply-To: From: Newsgroups: comp.databases.oracle,comp.databases.oracle.tools References: <42ffa8fa.0208061214.6219bf15@posting.google.com> <42ffa8fa.0208071943.4dc4255@posting.google.com> Subject: Re: Intermedia Catalog Indexing Lines: 12 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-GC-Trace: gv1-cl6GLXj/DGfXCjmEmX382sswypAwNeqcI8x Message-ID: NNTP-Posting-Date: Thu, 08 Aug 2002 07:05:36 CDT Organization: Giganews.Com - Premium News Outsourcing X-Trace: sv3-WWwMErsIEc6Afz3aLWQgBY0IY/GQpIzLltDTDPMPRn7B0Lt7FDv6SnN3ViE+cueorWcEUYP9Og5v5sj!pYkYXYbhcN9z5Aaq9S2pdts7OvoS0dW6r0HN66HU3qs/NlemjAy7EAxa/MhNed3wMRn01UBjm1Zn!H0O+Z9xXeTDDvftxAtz5ubvBTyjqqQ== X-Complaints-To: abuse@comcast.com X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.1 Date: Thu, 08 Aug 2002 12:05:36 GMT Xref: easynews comp.databases.oracle:16838 comp.databases.oracle.tools:52905 X-Received-Date: Thu, 08 Aug 2002 05:02:57 MST (news.easynews.com) "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