oracle分页

SELECT FROM ( SELECT T., ROWNUM RN FROM ( SELECT * FROM 表名 WHERE 条件 ) T WHERE ROWNUM <= ( ( currentPage - 1 ) * pageSize + pageSize ) ) WHERE RN > ( (

posted on 2023-11-03 11:02  帅哥川  阅读(1)  评论(0)  编辑  收藏  举报