笛卡尔积分页

您需要将DISTINCT进一步推入查询中,以便它已经完成 之前 应用分页。例如:

select deptno from
  ( select deptno, rownum as rn from
      ( select DISTINCT deptno
        from   emp
        order by deptno
      )
    where rownum < :pagenum*100
  )
where rn > (:pagenum-1)*100;