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

[Anthony Baratta]

 > 
> 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