Breaking News: Grepper is joining You.com. Read the official announcement!

pagination with row_number

Attractive Addax answered on May 7, 2020 Popularity 3/10 Helpfulness 1/10

answer pagination with row_number

pagination with row_number

Comment

DECLARE @Index INT;
DECLARE @PageSize INT;

SET @Index = 3;
SET @PageSize = 5;

SELECT *  FROM
  (SELECT  ROW_NUMBER() OVER (ORDER BY EmpID asc) as MyRowNumber,*
  FROM Employee) tblEmployee
WHERE MyRowNumber BETWEEN ( ((@Index - 1) * @PageSize )+ 1) AND @Index*@PageSize

Popularity 3/10 Helpfulness 1/10 Language sql

Source: dba.stackexchange.com

Tags: pagination sql

Link to this answer
Share Copy Link