Oracle总结

 

https://blog.csdn.net/weixin_44563573/article/details/88932384

 

Oracle原始分页Sql

select tt.name, tt.id
from 
(
    select a.name, a.id rownum rn
    from table t
    where t.id = #{id}
    and rownum <= #{pageNo} * #{pageSize}
) tt 
where tt.rn > #{pageNo} * #{pageSize} - #{pageSize}