3 ms·
It took a while, but SQL Server 2012 introduced OFFSET/FETCH: SELECT * FROM items ORDER BY key OFFSET 100 ROWS FETCH NEXT 10 ROWS ONLY (https:
by Someone 10y ago
It took a while, but SQL Server 2012 introduced OFFSET/FETCH:
SELECT * FROM items
ORDER BY key
OFFSET 100 ROWS
FETCH NEXT 10 ROWS ONLY
(https://technet.microsoft.com/en-us/library/gg699618(v=sql.110).aspx https://technet.microsoft.com/en-us/library/gg699618(v=sql.1...)