Easy way apply paging in SQL Query
Steps by Step
-
Pass the page number and how many records per page you would like to fetch
- Remember to have ORDER BY column name in your query
DECLARE @PageNumber AS INT,
@RowsperPage AS INT
SET @PageNumber = 1
SET @RowsperPage = 10
SELECT *
FROM cu_customer
ORDER BY CustomerID
OFFSET ((@PageNumber – 1) * @RowsperPage) ROWS
FETCH NEXT @RowsperPage ROWS ONLY OPTION (RECOMPILE);
Arjun's Blog 