1:select sampling,count(*) from aa group by sampling having count(*)>1; 转载于:https://www.cnblogs.com/zqzdong/p/4894953.html