SQL Function Reference

ROW_NUMBER

Window function. Returns the line number, used for numbering

MySQL

ROW_NUMBER()

Examples

MySQL

SELECT member_name,
	STATUS,
	ROW_NUMBER() OVER(
		ORDER BY STATUS
	) AS 'row_number'
FROM FamilyMembers;