3.sql

行业应急系统 包括: 应急系统（待遇核发） 发放系统 开发环境:Delphi5 (sp1)+ Oracle 8.05 MultiExport是一个可以将数据按指定字段倒出

select count(*) from tff_dwxx where sjdwdm='1000000000' --185
select count(*) from tff_dwxx where sjdwdm='1000000000' and khmc like '%农行%' or khmc like '%农业%'--137
--select count(*) from tff_dwxx where sjdwdm='1000000000' and khmc like '%工行%' or khmc like '%工商%' --20
--select count(*) from tff_dwxx where sjdwdm='1000000000' and khmc like '%建行%' or khmc like '%建设%' --14
--select count(*) from tff_dwxx where sjdwdm='1000000000' and khmc like '%中行%' --4
select count(*) from tff_dwxx where sjdwdm='1000000000' and khmc like '%人保%' --4