orcale分页语句查询没有结果显示，rownum和order by冲突

来源：互联网发布：网络小贷停止放款编辑：程序博客网时间：2024/05/18 01:17

select *
from (select rownum rno, t1.*
          from (select t.id itemid,
                       decode(p.id, null, 'no', '', 'no', 'yes') hassetup,
                       p.id postid,
                       t.sxzxname sxzxname,
                       d.deptid deptid,
                       d.shortname,
                       p.jjr_yb jjryb,
                       p.jjr_dw jjrdw,
                       p.jjr_dz jjrdz,
                       p.jjr_dh jjrdh
                  from t_share_permissionitem t
                  left join website.t_webhall_permissionitem_post p on t.id =
                                                                       p.sxbh,
                 t_sys_dept d
                 where t.department = d.deptid
                   and d.areaid =
                       (select areaid
                          from t_sys_dept
                         where deptid = '200703100000000001')
                   and d.deptid = '200608181530081000'
                 ) t1) p
where p.rno > 0
   and p.rno <= 10

原来，是最原始的sql里面，order by和外面的rownum冲突了，把里面的order by 去掉，终于成功了