SQL Function Reference

DENSE_RANK

Window function. Returns the rank of each row. But unlike the RANK function, it returns the rank for identical values, without skipping the next one

MySQL

DENSE_RANK()

Examples

MySQL

SELECT 
    member_name, 
    status, 
    DENSE_RANK() OVER(ORDER BY status) AS 'dense_rank' 
    FROM FamilyMembers;