SQL SERVER的分页:
select * from ( select TOP pagesize * FROM ( SELECT TOP pagesize*cureentpage * from user_table ORDER BY id ASC ) as aSysTable ORDER BY id DESC ) as bSysTable ORDER BY id ASC
boolean absolute(int row) 将指针移动到此 ResultSet 对象的给定行编号
DB2的分页:
通过在SQL语句中加ROW_NUMBER() over(添加要指定排序的列名) as a,在SQL语句后面用a.(要查的数据的位置)
ORCALE的分页:
通过在SQL语句中加rownum r,在SQL语句后面用r.(要查询的数据的位置)