select min(id) from bangongwenjian_qianshou group by wenjianid,qianshouren
delete from bangongwenjian_qianshou where id not in(
delete from bangongwenjian_qianshou where id not in(
select min(id) from bangongwenjian_qianshou group by wenjianid,qianshouren)
按要排除重复的字段分组然后删除id小或者大的就可以了