If you're using sqlserver 2005, try this: http://www.singingeels.com/Articles/Pagination_In_SQL_Server_2005.aspx SELECT TOP 5 * FROM (SELECT ROW_NUMBER() OVER (ORDER BY ID) AS RowNumber, * FROM CD_info) _myResults WHERE RowNumber > 5If sql server 2000, try this: http://weblogs.sqlteam.com/jeffs/archive/2004/03/22/sql-server-2000-paging.aspx
SELECT TOP 5 * FROM (SELECT
ROW_NUMBER() OVER (ORDER BY ID) AS RowNumber,
*
FROM
CD_info) _myResults
WHERE
RowNumber > 5If sql server 2000, try this: http://weblogs.sqlteam.com/jeffs/archive/2004/03/22/sql-server-2000-paging.aspx