/*日期的操作包含在子查询中,oracle测试通过*/
SELECT count(*), c.lrr_dm
FROM jc_ajxx c
WHERE c.jczt_dm IN ('01', '02', '10')
and c.ajbh in
(select count(*),aa.lrr_dm from
(select cc.lrr_dm, cc.ajbh, (sysdate - (cc.aydjrq + 9)) as span from jc_ajxx cc ) aa where span > 2000
group by aa.lrr_dm)
GROUP BY c.lrr_dm
SELECT count(*), c.lrr_dm
FROM jc_ajxx c
WHERE c.jczt_dm IN ('01', '02', '10')
and c.ajbh in
(select count(*),aa.lrr_dm from
(select cc.lrr_dm, cc.ajbh, (sysdate - (cc.aydjrq + 9)) as span from jc_ajxx cc ) aa where span > 2000
group by aa.lrr_dm)
GROUP BY c.lrr_dm