3.sql

来自「行业应急系统 包括: 应急系统（待遇核发） 发放系统 开」· SQL 代码 · 共 7 行

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