Select Row Number From Sql

SELECT ROW_NUMBER() OVER(ORDER BY IDP DESC) AS SrNo,Name FROM tblAgent