Re: This is how U can find out the 'N'th maximum value from a table by sql

Analytic functions are elegant and efficient, and extremely useful.

http://gethelp.devx.com/techtips/oracle_pro/10min/10min1200/10min1200-2.asp http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/function.htm#85693

and check asktom.oracle.com as well.

tom.mcclelland_at_mondas.com (Tom McClelland) wrote in message news:<cb748650.0202200233.6160564d_at_posting.google.com>...
> Thank you, I'll investigate RANK to see if it helps solve my (minor
> cos its internal need not someone who pays us money) top n% problem.
> Basically I've got a table full of support-issue durations, and once a
> week I need to know the issue-duration at various percentiles (ie 20%
> of calls solved within 10 minutes, 40% within 25 minutes, 80% within
> 36 years<G>.....etc) Much more useful measure of support-desk
> efficiency for me than average closure time which gets distorted by
> the unsolvable issues and unavailable clients.
> There's obviously a ton of solutions to this kind of problem. I was
> interested in spotting an elegant one as most are rather unpleasant
> kludges.
Received on Wed Feb 20 2002 - 17:15:37 CET