本文详细介绍了如何通过SQL查询语句从TC表中删除重复的账户名以及非最小ID记录，确保数据的唯一性和一致性。
delete from tc_Table
WHERE (account_name IN
(SELECT account_name
FROM tc_Table
GROUP BY account_name
HAVING COUNT(account_name) > 1))
and id not in (select min(id) from tc_Table group by account_name having count(tc_Table)>1)
WHERE (account_name IN
(SELECT account_name
FROM tc_Table
GROUP BY account_name
HAVING COUNT(account_name) > 1))
and id not in (select min(id) from tc_Table group by account_name having count(tc_Table)>1)
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
