--oracle删除重复行,一定是设置主键才能用
delete from SYS_ROLE_FUNCTION a
where exists(
select * from SYS_ROLE_FUNCTION
where srfu_id<a.srfu_id,srfu_sfun_id,srfu_srol_id
)
--oracle删除重复行,可以不用主键,推荐使用
delete from SYS_ROLE_FUNCTION a where rowid<>(
select max(rowid) from SYS_ROLE_FUNCTION where srfu_id=a.srfu_id and srfu_sfun_id = a.srfu_sfun_id and srfu_srol_id = a.srfu_srol_id
)