RDBMS Type: MySQL
Returns the number of the current row within its partition. Rows
numbers range from 1 to the number of partition rows.
ORDER BY affects the order in which rows are numbered. Without ORDER
BY, row numbering is nondeterministic.
ROW_NUMBER() assigns peers different row numbers. To assign peers the
same value, use RANK() or DENSE_RANK(). For an example, see the RANK()
over_clause is as described in