数据库查询重复id数据

 子查询

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'
);