Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Ranking with partition

Re: Ranking with partition

From: Marc Blum <marc_at_marcblum.de>
Date: Sat, 20 Jul 2002 14:01:02 +0200
Message-ID: <fvjijugocn7ojh8320ejou67aijktfqtqs@4ax.com> 





On Fri, 19 Jul 2002 23:04:32 -0700, "Yanick Hudon" <yannik_at_sympatico.ca> wrote:



>




how about wrapping another ranking view, (PARTITION BY CMC ORDER BY RANG),
around your actual query?



As long as your base tables are not in the 7th magnitude, you can do quite
spectacular things with analytic functions wrapped around in several layers.




Marc Blum


mailto:marc_at_marcblum.de


http://www.marcblum.de
Received on Sat Jul 20 2002 - 07:01:02 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US