--tab表中字段A为准分组,字段B下有不同值的数据统计 select t.A,count(distinct B) from tab t group by t.A having count(distinct B)>1;