LIMIT 10..20 in SQL Server

by

For SQL Server 2012 + you can use.

SELECT  *
FROM     sys.databases
ORDER BY name 
OFFSET  5 ROWS 
FETCH NEXT 5 ROWS ONLY

More Related Contents:

  1. Equivalent of LIMIT and OFFSET for SQL Server?
  2. What is the best way to paginate results in SQL Server
  3. efficient way to implement paging
  4. Implement paging (skip / take) functionality with this query
  5. SQL Server 2008 paging methods?
  6. T-SQL Skip Take Stored Procedure
  7. Run a query with a LIMIT/OFFSET and also get the total number of rows
  8. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  9. How can I do an UPDATE statement with JOIN in SQL Server?
  10. Why does NULL = NULL evaluate to false in SQL server
  11. Simplest way to do a recursive self-join?
  12. How to calculate percentage with a SQL statement
  13. A table name as a variable
  14. How to set table name in dynamic SQL query?
  15. TSQL PIVOT MULTIPLE COLUMNS
  16. Find the smallest unused number in SQL Server
  17. Can a sql server table have two identity columns?
  18. Saving changes after table edit in SQL Server Management Studio
  19. Logging ALL Queries on a SQL Server 2008 Express Database?
  20. SQL query to find Nth highest salary from a salary table
  21. MS SQL “ON DELETE CASCADE” multiple foreign keys pointing to the same table?
  22. Errors in SQL Server while importing CSV file despite varchar(MAX) being used for each column
  23. Should I use SQL_Variant data type?
  24. Get the records of last month in SQL server
  25. Log record changes in SQL server in an audit table
  26. Access to Result sets from within Stored procedures Transact-SQL SQL Server
  27. alternatives to REPLACE on a text or ntext datatype
  28. How can I backup a remote SQL Server database to a local drive?
  29. Getting the Id of a row I updated in Sql Server
  30. How to Execute SQL Query without Displaying results

Leave a Comment