SQL Pagination

Pagination is a regular technique used for developing web applications. There are numerous methods of implementing pagination . Suitable for web developers and DB developers

 

--Method 1

/**Replace X & y with relevant numbers

**/

SELECT * FROM (SELECT TOP x * FROM (	SELECT TOP y fields FROM table		WHERE conditions	ORDER BY table.field  ASC) as foo	
         ORDER by field DESC) as bar
         ORDER by field ASC

 Related Posts

SQL Server Development