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;