Row Numbers in SQL Query

SELECT row_number() OVER (ORDER BY EmployeeId) AS RowNumber,
    EmployeeID FROM EmployeeMaster

OutPut :    RowNumber   EmployeeID
                       1                A001
                       2                A008
                       3               A012