2.sql

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

select count(*) from tff_dwxx where sjdwdm='1000000000'

select * from tff_dwxx
where sjdwdm='1000000000' and khmc not like '%农行%' and khmc not like '%农业%'--137
and khmc not like '%工行%' and khmc not like '%工商%' --20
and khmc not like '%建行%' AND khmc not like '%建设%' --14
and khmc not like '%中行%'