2.sql

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

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 '%中行%'