摘要：mysql 分页 SELECT * FROM TABLE_NAME LIMIT 10, 20 ;SQL Server 2005 2000 SELECT TOP @pagesize * FROM TABLE_NAME WHERE id not in (SELECT TOP @pagesize*(@page-1) id FROM TABLE_NAME ORDER BY id) ORDER BY id 阅读全文