I think it is not difficult, but, how to get the result of TOP 10 students? By using the Serial Number Descending Order Method, it works fine, but the problem is that the continues serial number is not same for more then 1 student with same Marks Obtained. For Example
RANK Student ID Marks
1 1022 104
2 1029 101
3 1043 101
4 1023 99
From the above example, it shows that the Student 1029 and 1043 got same marks i.e. 101, but their RANKs are not same, it must be same i.e. 2 for both students.
Any help is highly appreciated.
Jamal