数据库表user只有id,name两个字段,编程实现删除重复数据,确保相同name的用户只有一条数据
DELETE a
from user a left OUTER join (SELECT min(id) as id
FROM
user
group by name
) b on a.id = b.id
where b.id is NULL
数据库表user只有id,name两个字段,编程实现删除重复数据,确保相同name的用户只有一条数据
DELETE a
from user a left OUTER join (