34,575
社区成员
发帖
与我相关
我的任务
分享
好象少了个括号
delete from
tb
where
exists
(
select
1
from
tb
where
name is null and id in(select id from tb group by id having count(1)>1))
delete from
tb
where
exists(select 1 from tb where name is null and id in(select id from tb group by id having count(1)>1)