Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need Recommendation on Which Analytic to Use
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
![]() |
![]() |