DENSE_RANK
Window function. Returns the rank of each row. But unlike the RANK function, it doesn't skip ranks and after a group of identical values, the rank increases by one, not by the number of rows
Examples
SELECT member_name,
STATUS,
DENSE_RANK() OVER(
ORDER BY STATUS
) AS 'dense_rank'
FROM FamilyMembers;