what is the use of Row_Number() OVER in Sql Server?

one of the features that to discuss in this article is the Row_Number() function. Row_Number() OVER is used to generate the row numbers automatically. The following query is used to generate the row number automatically in sql server.

Select Row_Number() OVER(Order By column1) As RowNumber,column1,column2 From TableName

Ex:
Select Row_Number() OVER(Order By EmpId) As RowNumber,EmpId,EmpName,Dob,Address,City,Phone From Employee