資料校正函數

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 ) ;---價表項目部在診療項目中的