DECLARE @page INT, @size INT;
select @page = 300, @size = 10
SELECT *
FROM gpcomp1.GPCUST
WHERE company like 'a%'
ORDER BY CUSTNO
OFFSET (@page -1) * @size ROWS
FETCH NEXT @size ROWS ONLY;
转载于:https://www.cnblogs.com/princessd8251/p/3811674.html
DECLARE @page INT, @size INT;
select @page = 300, @size = 10
SELECT *
FROM gpcomp1.GPCUST
WHERE company like 'a%'
ORDER BY CUSTNO
OFFSET (@page -1) * @size ROWS
FETCH NEXT @size ROWS ONLY;
转载于:https://www.cnblogs.com/princessd8251/p/3811674.html