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

[r937]

> This way you don't lop off any at the "high" end that 
> are equal to the highest result allowed at 95%.
>
> Rudy will set me straight, if I'm way off base. :-)

i'm not sure i even understand what percentile means

but consider what would happen if you said

   SELECT AVG(score) 
     FROM ( SELECT TOP 95 PERCENT WITH TIES score 
              FROM dbo.TestScores
            ORDER 
                BY score DESC
          ) AS Top95PercentAvg
   
notice the ORDER BY is DESC

that way, "with ties" will lop off any extra piddly ones at the bottom

is that still a 95th percentile?

--
rudy
http://r937.com/