删除多个字段重复的数据

delete from SYS_ROLE_MENU where ROWID not in (select min(ROWID) from SYS_ROLE_MENU group by ROLE_NO, MENU_NO);