oracle分页查询
oracle 分页采用rownum来实现,内层小于等于,外出大于
SELECT *
FROM (SELECT A.*, rownum rn
FROM (SELECT * FROM table_Name) A
WHERE rownum <= pageIndex * pageSize)
WHERE rn > (pageIndex - 1)*pageSize
oracle 分页采用rownum来实现,内层小于等于,外出大于
SELECT *
FROM (SELECT A.*, rownum rn
FROM (SELECT * FROM table_Name) A
WHERE rownum <= pageIndex * pageSize)
WHERE rn > (pageIndex - 1)*pageSize