2020-02-16 标签:sql,语句,查询,数据库,重复记录,个数,实现,代码,如下,select,a,b,c,count,test,having,group,zdbh,tdzl

实现代码如下：select a,b,c,count(*) from (select c.a,c.b,c.c from test c) having count(*) >= 2 group by a,b,c 或者 实现代码如下：select zdbh,tdzl,zdmj,count(*) fro