SQL2000分页sql语句 SELECT TOP (10) --查询每页显示的数量 * FROM tablename WHERE id>(SELECT MAX (id) from (select top (2*10)id --查询的页数*每页显示的数量 from tablename order by id) as talTMP ) order by id