sql 查重

时间：2020-05-22 14:38:51 收藏：0 阅读：75

SELECT * FROM `表名1` WHERE 字段1 in(select sn from 表名1 group by 字段1 having count(*)>1)

SELECT sn ,count(*) as a FROM `表名` group by sn having a>1

原文：https://www.cnblogs.com/xiangangXu1997/p/12936488.html