Is there a way to get rank without using RANK function?
917017Mar 24 2013 — edited Mar 25 2013Hi,
I created a sample table named as "Student" with following data. table contains two columns only - stdid & marks.
stdid marks
10 75
20 60
30 60
40 45
50 30
I have to find the rank of students based on their marks in descending order.
Is there a way to get rank without using RANK function?
Please suggest me.
Regards,
Sachin Jaiswal