随笔分类 -  oracle

oracle分页
摘要:SELECT FROM ( SELECT T., ROWNUM RN FROM ( SELECT * FROM 表名 WHERE 条件 ) T WHERE ROWNUM <= ( ( currentPage - 1 ) * pageSize + pageSize ) ) WHERE RN > ( ( 阅读全文

posted @ 2023-11-03 11:02 帅哥川 阅读(15) 评论(0) 推荐(0)

导航