SELECT 字段, COUNT(*) as count
FROM 表名
GROUP BY 字段
HAVING COUNT(*) > 1;
SQL Server 中快速查出重复的列
最新推荐文章于 2024-07-19 03:29:12 发布
SELECT 字段, COUNT(*) as count
FROM 表名
GROUP BY 字段
HAVING COUNT(*) > 1;