03 2018 档案
mysql中利用group by过滤删除重复行
摘要：DELETEFROM peopleWHERE peopleId IN (SELECT peopleId FROM people GROUP BY peopleId HAVING count(peopleId) > 1)AND rowid NOT IN (SELECT min(rowid) FROM
阅读全文
