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;