How to implement rank system

deesh · Post by **deesh** » Sun May 31, 2009 5:29 am

Hi friends,

Can any one help to me how to implent the rank for a 1000 members in a class from 1 to 1000

If two students get same marks based on Maths marks we have to decide which student rank is higher than second one.

chulett · Post by **chulett** » Sun May 31, 2009 6:22 am

Sort. With a secondary sort criteria as a tie-breaker if there's no such thing as a tie.

ray.wurlod · Post by **ray.wurlod** » Sun May 31, 2009 4:17 pm

Rank is a display function. Most query languages support it, as do most business intelligence tools. Rank is not something you ought to be asking an ETL tool to do.