select keyField, count(x) from a group by keyField having count(x)>1;
这select X,count(*) from A group by x having count(*)>1
1 select msis from zhyw.tj_2002 a where msis is not null and 2 exists (select 1 from zhyw.tj_2002 b where a.msis = b.msis 3* and group by b.msis having count(*) >1)
group by keyField
having count(x)>1;
group by x
having count(*)>1
2 exists (select 1 from zhyw.tj_2002 b where a.msis = b.msis
3* and group by b.msis having count(*) >1)