row number partition by in mysql code example

Example: row number mysql

SELECT row_number() over ( order by firstName) RowNumberSqeuence,FirstName from rowNumberDemo
 order by FirstName;