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  
原文地址:https://www.cnblogs.com/northstar/p/1746864.html