select * from company c where exists (select 1 from company where 单位名称=a.单位名称 and 电话<>a.电话);
delete from company c where exists (select 1 from company where 单位名称=a.单位名称 and 电话 is not null) and 电话 is null
7,714
社区成员
28,799
社区内容
加载中
试试用AI创作助手写篇文章吧