转自:http://www.2cto.com/database/201312/262775.html
sql分页查询:
//oracle
select * from (select rownum rm, * from tableName where rownum<(startRow+rowNum)) where rm>=startRow;
//mysql
select * from tableName limit startRow , rowNum ;
//sqlserver
select top (startRow + rowNmu) from tableName ;
//db2
select * from tableName limit startRow , rowNum ;
//hsql
select limit startRow rowNum * from (select * from tableName) ;