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

Home -> Community -> Usenet -> c.d.o.server -> Re: Top 'N' Analysis

Re: Top 'N' Analysis

From: Lucyna Witkowska <ypwitkow_at_nospamcyf-kr.edu.pl>
Date: Thu, 25 Sep 2003 09:51:56 +0000 (UTC)
Message-ID: <bkudrs$913$1@srv.cyf-kr.edu.pl> 






fleeting_at_net1plus.com wrote:



> Well, I did copy the question and maybe I should have written it out

> to begin with:

 


> Top N analysis requires --- & --- (2)

> 1 - use of rowid

> 2 - group by

> 3 - order by

> 4 - only an inline view

> 5 - inline and outer query




 3 & 5  :-( (may be in 10i will be better)



Greetings,


LW
Received on Thu Sep 25 2003 - 04:51:56 CDT












Original text of this message













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