row_number function in sql server

row_number() :
   
        row_number numbers all rows sequentially

example:

select row_number() over(order by employeeid) as r_id, * from employee