RANK

A window function assigning equal rank to peers and leaving gaps after ties.

What is RANK in a relational database?

RANK — A window function assigning equal rank to peers and leaving gaps after ties.

SELECT student_id,
       RANK() OVER (ORDER BY score DESC) AS score_rank
FROM exam_result;

Level: Journeyman · More Database terms at this level

Updated