Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is there a way to get rank without using RANK function?

917017Mar 24 2013 — edited Mar 25 2013
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2013
Added on Mar 24 2013
11 comments
5,204 views