子查询
select distinct * from XXJBZ.SYS_DICT where id in (SELECT id
FROM (
SELECT id, COUNT(*) AS count
FROM SYS_DICT
GROUP BY id
HAVING COUNT(*) > 1
) AS duplicate_ids);
删除所有
delete from PRICE_COMPILE_LABOR where id in (SELECT id
FROM (
SELECT id, COUNT(*) AS count
FROM PRICE_COMPILE_LABOR
GROUP BY id
HAVING COUNT(*) > 1
) AS duplicate_ids)
达梦数据库查询某一用户下没有唯一索引的全部表
SELECT TABLE_NAME
FROM ALL_TABLES
WHERE OWNER = 'XXJBZ'
AND TABLE_NAME NOT IN (
SELECT TABLE_NAME
FROM ALL_CONSTRAINTS
WHERE OWNER = 'XXJBZ'
AND CONSTRAINT_TYPE = 'U'
);