home bbs files messages ]

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