原SQL
delete from DEP_SYSTEM_PORTLET_SETTINGS where ID in (
select ID from
DEP_SYSTEM_PORTLET_SETTINGS
group by (USER_ID) HAVING count(USER_ID) >1
)
修改后
delete from DEP_SYSTEM_PORTLET_SETTINGS where ID in (
select ID from (
select ID from
DEP_SYSTEM_PORTLET_SETTINGS
group by (USER_ID) HAVING count(USER_ID) >1
) C
)