row_number

Row number is very useful in ranking and sorting. Here is how to get row_number in MySQL.