[dba-SQLServer] Percent Rank Function in SQL

Arthur Fuller artful at rogers.com
Mon Mar 28 15:40:58 CST 2005


This is an old message but I don't see any responses to it, sorting by 
subject. Have you got your answer yet? If not, I will investigate. If 
so, please direct me to the response that solved your problem.

Arthur

Klos, Susan wrote:

>I need to use a Percent Rank function to determine which students are in the
>lowest 25% of a school.  We sort then rank the prior year developmental
>scale score by previous year's grade level.  Any ties need to be ranked
>down.  Then we flag the students whose rank is 25.44 or below as in the
>lowest 25%.  We do this for each grade level of the school (grade 3 - 10).
>If there are less than 30 students in the lowest 25% of the school then we
>need to resort all of the rankings in the school and flag the lowest 30
>students.  This is a separate calculation and only really needs to be done
>if the lowest 25% does not contain enough students.  I hope this explanation
>is good enough to get someone to put me on the track of finding a Percent
>rank function.  Thanks for all your help.
>
> 
>
>Susan Klos
>
>Senior Database Analyst
>
>Evaluation and Reporting
>
>Florida Department of Education
>
>850-245-0708 
>
>sc 205-0708
>
> 
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>  
>



More information about the dba-SQLServer mailing list