How to generate row number in sql server

 

SELECT
    ROW_NUMBER() OVER( ORDER BY ColumnName),   
    ColumnName1, ColumnName2,... 
FROM TableName

Happy coding…