常用的SQL 总结

1、去重

SELECT * FROM my where id in(SELECT MAX(id) from my  GROUP BY id,iid,pid)//取 id,iid,pid重复的最大值