文件名称：分类统计三种单据数量
文件大小：2KB
文件格式：TXT
更新时间：2016-07-17 09:24:17
分类统计
select count(substring(orgid,1,3)),substring(orgid,1,3) from treccallback tcb, trecwork tw where CallbackTime between '2011-05-01 00:00:00' and '2011-05-30 00:00:59' and tw.telid=tcb.telid group by substring(orgid,1,3) order by substring(orgid,1,3)