题目:删除user表(含字段id和字段name)中重复的name字段,保留唯一的name字段,要求保留的name对应的id值最小。
delete
from
user
where
id
not
in
(
select
min
(id)
from
user
group
by
name
);
题目:删除user表(含字段id和字段name)中重复的name字段,保留唯一的name字段,要求保留的name对应的id值最小。
delete
from
user
where
id
not
in
(
select
min
(id)
from
user
group
by
name
);