字段3， 在差异数据库中的利用的分页查询语句： 当前页:currentpage 页巨细:pagesize 1. Oracle数据库 select * from (select A.*，rownumber() over(order by 排序用的列名 asc) as RN from 表名) as A1 where A1.RN between (currentpage*pagesize) and ((currentpage1)*pagesize) 或 select * from (select rownumber() over(order by id asc ) as rowid from table where rowid =((currentpage1)*pagesize) ) where rowid (currentpage*pagesize) 4. SQL Server数据库 select top pagesize * from TABLENAME where COLLUMN_NO not in (select top currentpage*pagesize COLLUMN_NO from TABLENAME order by COLLUMN_NO) order by COLLUMN_NO 5. Sybase数据库 Sybase 12.5.3版本支持top查询， column_name into #TEMPTABLE from TABLENAME select column_name from #TEMPTABLE where rowid (currentpage*pagesize) and rowid (currentpage*pagesizepagesize) 6. MySQL数据库 SELECT * FROM TABLE1 LIMIT (currentpage*pagesize)。

或利用set rowcount N查询头N条数据 别的回收姑且表： select rowid=identity(12)， 或 select * from (select rownum rn，id from TABLENAME where rownum =((currentpage1)*pagesize) ) A where A.rn = (currentpage*pagesize) 2. Infomix数据库 select skip currentpage first pagesize * from TABLENAME 3. DB2数据库 select * from (select 字段1。

字段2。

pagesize ，rownum rn from ( QUERY_SQL ) A ) where rn = ((currentpage1)*pagesize) and rn (currentpage*pagesize) 注：QUERY_SQL为查询sql语句，。