MySQL Function Reference

RANK

Window function. Returns the rank of each row, if identical ones are found, returns the same rank, skipping the next value

MySQL 8.1

RANK()

Examples

MySQL 8.1

SELECT member_name,
	STATUS,
	RANK() OVER(
		ORDER BY STATUS
	) AS 'rank'
FROM FamilyMembers;