1、去重
SELECT * FROM my where id in(SELECT MAX(id) from my GROUP BY id,iid,pid)//取 id,iid,pid重复的最大值
本文共 150 字，大约阅读时间需要 1 分钟。
1、去重
SELECT * FROM my where id in(SELECT MAX(id) from my GROUP BY id,iid,pid)//取 id,iid,pid重复的最大值
转载于:https://www.cnblogs.com/chenmfly/p/4583653.html