查询某个字段出现的次数:select A,count(*) from tableA group by A;
查询出现次数大于1的:select A,count(*) from tableA group by A having count(*) > 1;
查询某个字段出现的次数:select A,count(*) from tableA group by A;
查询出现次数大于1的:select A,count(*) from tableA group by A having count(*) > 1;