数据校验函数

select * from price_list where item_code in(select item_code  from (select count(item_code),ITEM_CODE  from price_list a  where item_class not in('A','B','I')  group by item_Code HAVING count(item_code) > 1 ) c);select * from clinic_item_dict where item_code in(select item_code  from (select count(item_code),ITEM_CODE  from price_list a  where item_class not in('A','B','I')  group by item_Code HAVING count(item_code) > 1 ) c) ;select * from clinic_item_name_dict where item_code in(select item_code  from (select count(item_code),ITEM_CODE  from price_list a  where item_class not in('A','B','I')  group by item_Code HAVING count(item_code) > 1 ) c) ;--查询是否有重复数据select * from price_list where item_name in(select item_name  from (select count(item_name),ITEM_name  from price_list a  where item_class not in('A','B','I')  group by item_name HAVING count(item_name) > 1 ) c);select * from clinic_item_dict where item_name in(select item_name  from (select count(item_name),ITEM_name  from price_list a  where item_class not in('A','B','I')  group by item_name HAVING count(item_name) > 1 ) c);select * from clinic_item_name_dict where item_name in(select item_name  from (select count(item_name),ITEM_name  from price_list a  where item_class not in('A','B','I')  group by item_name HAVING count(item_name) > 1 ) c);--查询名称是否有重复select * from price_list where item_name like '% %' or item_code like '% %' or item_spec like '% %' or units like '% %';select * from price_item_name_dict  where item_name like '% %' ;select * from clinic_item_dict where item_name like '% %' or item_code like '% %';select * from clinic_item_name_dict  where item_name like '% %' or item_code like '% %';select * from clinic_vs_charge  where charge_item_spec like '% %' or units like '% %';select * from drug_price_list   where drug_code like '% %' or drug_spec like '% %' or firm_id like '% %' or units like '% %';select * from drug_dict where drug_name like '% %' or  drug_code like '% %' or drug_spec like '% %' or units like '% %';select * from drug_stock where   drug_code like '% %' or drug_spec like '% %' or units like '% %' or firm_id like '% %';select * from exp_price_list   where exp_code like '% %' or exp_spec like '% %' or firm_id like '% %' or units like '% %';select * from exp_dict where exp_name like '% %' or  exp_code like '% %' or exp_spec like '% %' or units like '% %';select * from drug_stock where   drug_code like '% %' or drug_spec like '% %' or units like '% %' or firm_id like '% %';--查询是否有空格项目select * from clinic_vs_charge a  where  ( a.charge_item_class,a.charge_item_code ) not in(select item_class ,item_code from price_list ) ;select * from clinic_vs_charge a  where  ( a.charge_item_class,a.charge_item_code,a.charge_item_spec ) not in(select item_class ,item_code,item_spec from price_list ) ;----诊疗项目不在价表中的项目select * from price_list where (item_class,item_code) not in(select charge_item_class,charge_item_code  from clinic_vs_charge ) ;---价表项目部在诊疗项目中的