select* from `spu_sku_jingpian_danjiaodian` where k_id in(<br /><p>select max(k_id) from `spu_sku_jingpian_danjiaodian` group by k_spu_id, k_qulv, k_moceng, k_qiujing, k_zhujing, k_lianheguangdu, k_danwei having COUNT(*)>1)</p><p>max是取较大的主键，min是取较小的主键。</p><p>查询结果直接手动删除即可。<br /></p><p><br /></p>