coding
zhangzhifx的gravatar头像
zhangzhifx2013-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)

打赏

顶部客服微信二维码底部
>扫描二维码关注最代码为好友扫描二维码关注最代码为好友