SQL Server 2012 新的分页函数 OFFSET & FETCH NEXT时间:2023-03-09 04:34:10 DECLARE @page INT, @size INT;select @page = 300, @size = 10 SELECT *FROM gpcomp1.GPCUSTWHERE company like 'a%'ORDER BY CUSTNOOFFSET (@page -1) * @size ROWSFETCH NEXT @size ROWS ONLY;