SQL删除重复数据 保留id最大的一条

        delete
        from sys_role_permission
        where id not in (
            select t.max_id
            from (select max(id) as max_id from sys_role_permission group by role_id, permission_id) as t);