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;