i hv a table in which i hv total marks & % of stodents subject wise...
i want to give ranks to each student...as
student with heighset total get 1 nd so on
nd if two stu hv same total mks they gat same rank like 3
nd student below these two student get rank 5 inspite of 4
how to write query or any solution for this