Returning a Row Number in a Query

SELECT varEmpname,decAmount,varState
    ROW_NUMBER() OVER (ORDER BY varEmpname) AS 'RowNumber'
    FROM Employee_mst

RowNumber varEmpname decAmount  varState

 1        Nirav      15,000     Gujarat

 2        Ashish     25,000     Mumbai