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: Need Recommendation on Which Analytic to Use

Re: Need Recommendation on Which Analytic to Use

From: Bricklen <bricklen-rem_at_yahoo.comz>
Date: Tue, 11 May 2004 19:08:10 GMT
Message-ID: <uw9oc.50278$U75.49885@edtnps89>


Terry Coccoli wrote:

> Didn't get a nibble in the other newsgroup, so reposting here:
>
>
> I have a request to return the "lower quartile(maybe list the lowest 25%)"
> of providers who have called into the service center.
>
> This basically means that I need to do a COUNT(*) by provider and applying
> some kind of rank based on that count.
>
> I tried NTILE but since I'm ordering by a COUNT(*) exression, and many
> providers have the same count, I'm seeing the same counts across
> different quartiles. According to the docs, this is standard behaviour.
>
> I also tried using PERCENT_RANK, but it gives results in the range of 0
> to 1. I'm not sure how to evaluate the results to give me what I need.
>
>
> Any suggestions ?

No idea off the top of my head, but you can generally get some results from asktom.oracle.com Received on Tue May 11 2004 - 14:08:10 CDT

Original text of this message

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