Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.oracle    |    Overblown overpriced overengineered SHIT    |    2,288 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 1,385 of 2,288    |
|    Terry Coccoli to All    |
|    Not Sure Which Analytic To Use    |
|    10 May 04 12:59:39    |
      From: request@ifneeded.com              I have to count a bunch of calls into the service area by provider and       create a report of the "lower quartile(maybe list the lowest 25%)"              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 ?              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca