SELECT 目标列,count() as num
FROM 目标表
where 条件(可加可不加,看具体需求) GROUP BY 目标列 HAVING count()>1;
sql查重
最新推荐文章于 2022-09-15 21:13:47 发布
SELECT 目标列,count() as num
FROM 目标表
where 条件(可加可不加,看具体需求) GROUP BY 目标列 HAVING count()>1;