I'm wondering if there is a good way to simulate TOP N PERCENT using RANKING functions? NTILE() comes close, but it doesn't simulate it exactly. It almost looks like we need a new PERCENTILE() ranking function.
Thanks in advance.
Premature optimization is the root of all evil in programming.
(c) by Donald Knuth
Naomi Nosonovsky, Sr. Programmer-Analyst
View Complete Post