Re: Top 'N' Analysis

Thanks Bricklen for the reply. However, this is the first test toward a DBA certificate - we never covered analytic functions etc. Just beginning SQL, queries, views, etc - nothing having to do with functions.

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

My mistake - I should have written the whole thing out.

Kevin

On Wed, 24 Sep 2003 20:07:19 GMT, Bricklen <bricklen-rem_at_yahoo.comz> wrote:

>fleeting_at_net1plus.com wrote:
>> I'm studying to get my DBA in Oracle 9i. After I went through the 3
>> CD's sent to me, I took the first test and found a question that I
>> never saw on the CD's! It refered to Top 'N' Analysis.
>>
>> I tried going through the CD's again just to see if maybe I missed
>> something, but still cannot find the reference to Top 'N' analysis.
>>
>> Can someone give me a head's-up as to what this is? Even better - can
>> you tell me where on the three CD's I may have missed this?
>>
>> Thank you for your help - great group!
>>
>> Kevin
>
>Take a look for analytic functions at tahiti.oracle.com and
>asktom.oracle.com lots of info in both places
  Received on Thu Sep 25 2003 - 04:19:05 CDT