منطق کوئری اشکال داره. جای مساوی باید عوض بشه:
Select *
FROM (Select ROW_NUMBER () OVER (Order By EmpID) RowID, *
FROM Employees) as t
WHERE t.RowID > (@Page -1)*10 AND RowID <= (@Page * 10)
/* OR
;with cte as
(
Select ROW_NUMBER () OVER (Order By EmpID) RowID, *
FROM Employees
)
select *
from cte
where cte.RowID > (@Page-1)*10 and cte.RowID <= (@Page*10)
*/
پاسخ با نقل قول