<\/span><\/h2>\n\n\n\nIn this case, we mention ORDER BY clause within OVER() function. The ORDER BY clause ensures that the row numbers are consistent and predictable. This is one of the most common ways to get row number.<\/p>\n\n\n\n
Here is the query to implement this.<\/p>\n\n\n\n
#- select id,product,orders,
row_number() over (order by orders desc) as row_num
from sales;
+------+---------+--------+---------+
| id | product | orders | row_num |
+------+---------+--------+---------+
| 3 | A | 70 | 1 |
| 2 | B | 60 | 2 |
| 1 | A | 50 | 3 |
| 5 | C | 50 | 4 |
| 1 | A | 50 | 5 |
| 4 | B | 40 | 6 |
| 4 | B | 40 | 7 |
+------+---------+--------+---------+<\/pre>\n\n\n\nIn this query, the entire table is considered as a single group of rows. Its rows are ordered by orders column. Then each row is sequentially numbered starting from 1. In case of a tie in orders<\/em> column value, row number is sequentially assigned.<\/p>\n\n\n\nThis solution is useful if you want to sequentially number all rows in a table, without any partitioning.<\/p>\n\n\n\n