Row_Number() function in Microsoft SQL server | How to use Row_Number in SQL server

Row_Number is used to generate the number of each row dynamically in a sequential order based on some column orders.

source https://www.c-sharpcorner.com/article/rownumber-function-in-microsoft-sql-server-how-to-use-rownumber-in-sql-ser/