One SQL statement handles SQL Server 2000 Paging

1. page size of all records: select top page size * FROM UsersWHERE (id not in (select top (page size * (page size-1) id from Users order by id desc )) // skip (page size * (page size-1) record order by id desc 2. page that meets the condition record (note that your query conditions should be distributed in two query statements, remember)

Select top page size * FROM UsersWHERE + your query condition AND (id not in (select top (page size * (page size-1 )) ID where + your query condition FROM Users order by id desc) ORDER BY ID DESC