Oracle总结

 

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

 

Oracle原始分页Sql

?

1 2 3 4 5 6 7 8 9

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}