sql删除重复数据
DELETE FROM city_info WHERE 1=1 AND admin_id IN ( SELECT * from ( SELECT admin_id FROM city_info GROUP BY admin_id HAVING COUNT(admin_id)>1 ) as A) AND id NOT IN ( SELECT * from ( SELECT MIN(id) FROM city_info GROUP BY admin_id HAVING COUNT(admin_id)>1 ) as B)
温馨提示: 本文由Jm博客推荐，转载请保留链接: https://www.jmwww.net/SQL/21070.html
- 上一篇：数据库的一些基本应用
- 下一篇：mysql 视图使用
