select count(*) from table group by zd having count(*)>1 这是不唯一的过滤出来的语句 转载于:https://www.cnblogs.com/yuhuameng/p/5198036.html