paging from database

WITH PAGING AS(
 
  SELECT   ROW_NUMBER() OVER (ORDER BY  DATESENT DESC) AS SRNO, [LogID]
      ,[TemplateID]
      ,[MailFrom]
      ,[MailTo]
      ,[Subject]
      ,[IsAttachment]
      ,[MailStatus]
      ,[DateSent]
      ,[EmailContent]
  FROM tablename )
  )
  SELECT *,(SELECT COUNT(*) FROM PAGING) AS TotalRecords FROM PAGING AS  PG WHERE SrNo BETWEEN(@PageIndex- 1) * @PageSize +1 AND @PageIndex*@PageSize