MYSQL 删除重复项

delete from g_user_pay_info  where id in (  select id from (select  max(id) as id,  count(role_id) as count from g_user_pay_info group by role_id   having count >1order by count desc) as tab )