SQL查询某个字段有重复记录的代码

Vincent
代码笔记
-271分钟前
3热度
0评论

SELECT *
FROM KeHuWuLiaoTable
WHERE 子编码 IN (
    SELECT 子编码
    FROM KeHuWuLiaoTable
    GROUP BY 子编码
    HAVING COUNT(*) > 1
);