摘要： 例如：id name value1 a pp2 a pp3 b iii4 b pp5 b pp6 c pp7 c pp8 c iiiid是主键要求得到这样的结果id name value1 a pp3 b iii4 b pp6 c pp8 c iii方法1delete YourTable where [id] not in ( select max([id]) from YourTable group by (name + value)) 方法2delete a from 表 a left join( select ... 阅读全文