日期:2014-05-17 浏览次数:20889 次
select to_char(a.startdate,'yyyy'), count(*) from V_MQBAODANCHEXIAN_NEW_TUANDAN a where a.isdname like '%畅通%' and a.branchno = 'AEAE00' group by rollup (to_char(a.startdate,'yyyy'))
select to_char(a.startdate,'yyyy'), count(*) from V_MQBAODANCHEXIAN_NEW_TUANDAN a where a.isdname like '%畅通%' and a.branchno = 'AEAE00' group by to_char(a.startdate,'yyyy')
select count(*) from V_MQBAODANCHEXIAN_NEW_TUANDAN a where a.isdname like '%畅通%' and a.branchno = 'AEAE00'