Here, you will learn how to use custom paging in SQL Server, using OFFSET-FETCH clause.
  1. CREATE PROC Test_Paging
  2. @Pagenumber INT =0, --Default page size 0
  3. @Pagesize INT=10
  5. AS
  7. BEGIN
  9. SELECT Row_number() OVER ( ORDER BY UserID DESC ) [RowNo] ,
  10. FirstName,LastName,EmailID
  11. FROM Employee (NOLOCK)
  13. ORDER BY UserID
  15. OFFSET @Pagenumber * @Pagesize ROWS
  17. FETCH NEXT @Pagesize ROWS ONLY;
  19. END;