无效月份
select * from (select rownum no, au.* from (select a.*,u.*,floor(months_between(SYSDATE, to_date(case when length(a.TB_ADMIN_BIRTHDAY)>2 then a.TB_ADMIN_BIRTHDAY else '2017-01-01' end,'yyyy-mm-dd'))/ 12) as age from tb_Admin a inner join (select DISTINCT adminid,jieci from admindeptjc where dutycode is not null and jieci = 12245) ad on a.tb_admin_id = ad.adminid left join tb_user u on u.tb_user_id = a.tb_admin_id left join duty d on a.dutycode = d.code where a.TB_ADMIN_LOGINNAME <> 'admin' and a.TB_ADMIN_STATUS = 's' and u.tb_user_status = 's' and a.TAG is null order by orderno ) au) x where x.no > 0 and x.no <= 30