LIMIT 10..20 in SQL Server May 9, 2022 by Tarik For SQL Server 2012 + you can use. SELECT * FROM sys.databases ORDER BY name OFFSET 5 ROWS FETCH NEXT 5 ROWS ONLY