SELECT FROM ( SELECT T., ROWNUM RN FROM ( SELECT * FROM 表名 WHERE 条件 ) T WHERE ROWNUM <= ( ( currentPage - 1 ) * pageSize + pageSize ) ) WHERE RN > ( ( currentPage - 1 ) * pageSize )
posted on 2023-11-03 11:02 帅哥川 阅读(1) 评论(0) 编辑 收藏 举报