oracle分页语句

11 |

2 | 2017-11-24 15:34:45 | 显示全部楼层 |阅读模式

String sql = "select * from student whererowCount> "+currentPage*(pageSize-1)+" and rowCount= (currentPage-1)*pageSize；这个意思就是认为的在sql中添加hint 数据库返回指定条目的数据是最快的...

使用道具举报

千问 | 2017-11-24 15:34:45 | 显示全部楼层

1.oracle数据库分页select * from (select a.*,rownum rc from 表名 where rownum=startrow2.DB2数据库分页Select * from (select rownumber() over() as rc,a.* from (select *...

使用道具举报