[thelist] SQL Server 2008 - How to get the 95% percentile?

Anthony Baratta anthony at baratta.com
Tue Jun 14 16:17:20 CDT 2011

> There is a little trickiness though.  For measures where 'larger' is 'better', I think you may have to take the top 95% records *ascending* ... and then grab the *max* value from that set.  I believe that should give you the value for the 95% percentile.  

Correct, you can ASC or DESC, *but* lopping off the bottom/low numbers and taking the "max" will not change your value from not lopping off the bottom/low. I think for 95th Percentile you want the lop the "top" 5% then take the Max. 

But my Stats is olde and dusty. 

Anthony Baratta

More information about the thelist mailing list