We often come across situations where we have to rank things/persons based on certain criteria, such as ranking Students based on their scores.

Take, for example, a SCORES table with two columns: STUDENT_IDVARCHAR2(10), SCORE NUMBER(5). To rank these Students based on their scores, a straightforward approach is to open a cursor, order them by SCORE and then loop through the cursor to Rank them.

However, there is another very short approach for this that takes 1 SQLstatement. Let