zhangzhifx
2013-11-26 17:08:18
Oracle数据库分页查询sql模板
select * from (
select rownum rw,i.* from (
select * from tableName
) i
where rownum <= pageSize*currentPage
) ii
where ii.rw > pageSize*(currentPage-1)
猜你喜欢
相关代码
最近下载
最近浏览
