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
* FROM tablename
WHERE id>(SELECT MAX (id)
from (select top (2*10)id --查询的页数*每页显示的数量
from tablename order by id) as talTMP ) order by id