How to do pagination in SQL Server 2008

by

You can use ROW_NUMBER():

Returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.

Example:

WITH CTEResults AS
(
    SELECT IDColumn, SomeField, DateField, ROW_NUMBER() OVER (ORDER BY DateField) AS RowNum
    FROM MyTable
)

SELECT * 
FROM CTEResults
WHERE RowNum BETWEEN 10 AND 20;

More Related Contents:

  1. to select all the employees who have joined most recently under king
  2. Unpivot with column name
  3. How can I delete using INNER JOIN with SQL Server?
  4. SQL NVARCHAR and VARCHAR Limits
  5. How to group time by hour or by 10 minutes
  6. Convert varchar into datetime in SQL Server
  7. sql query to return differences between two tables
  8. SQL Joins Vs SQL Subqueries (Performance)?
  9. Check if a row exists, otherwise insert
  10. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  11. Convert Xml to Table SQL Server
  12. SQL Server : dynamic pivot over 5 columns
  13. How to select the last record of a table in SQL?
  14. Using a Variable in OPENROWSET Query
  15. How to create table using select query in SQL Server?
  16. Check for file exists or not in sql server?
  17. How do I remove redundant namespace in nested query when using FOR XML PATH
  18. SQL SERVER: Get total days between two dates
  19. SQL Server 2008 – Help writing simple INSERT Trigger
  20. T-SQL and the WHERE LIKE %Parameter% clause
  21. Store multiple bit values in a single table column
  22. SQL Server equivalent to MySQL enum data type?
  23. Grant SELECT permission on a view, but not on underlying objects
  24. Using IF ELSE statement based on Count to execute different Insert statements
  25. Backup a single table with its data from a database in sql server 2008
  26. COALESCE Function in TSQL
  27. SQL Server equivalent to MySQL’s EXPLAIN
  28. Try_Convert for SQL Server 2008 R2
  29. SQL: Using DATEADD with bigints
  30. How do you read XML column in SQL Server 2008?

Leave a Comment