DELETE FROM j_rank_rise_record WHERE id NOT IN ( SELECT id FROM ( SELECT * FROM j_rank_rise_record group by userid,rank_lv ) t )
mysql 删除重复项
原文：https://www.cnblogs.com/qingyibusi/p/9282992.html
