摘要： 1.oracle数据库分页select * from (select a.*,rownum rc from 表名 where rownum=startrow2.DB2数据库分页Select * from (select rownumber() over() as rc,a.* from (select * from 表名 order by 列名) as a) where rc between startrow and endrow3.SQL Server 2000数据库分页Select top pagesize * from 表名 where 列名 not in(select top page 阅读全文