表里有如下字段:
去重:
DELETE
FROM SYS_USER_ROLE a
WHERE rowid > ( SELECT min(rowid)
FROM SYS_USER_ROLE b
WHERE a.user_id=b.user_id and a.role_id=b.role_id);
表里有如下字段:
去重:
DELETE
FROM SYS_USER_ROLE a
WHERE rowid > ( SELECT min(rowid)
FROM SYS_USER_ROLE b
WHERE a.user_id=b.user_id and a.role_id=b.role_id);