MySql--查询某字段相同数据的条数据

1：select sampling,count(*) from aa  group by sampling having count(*)>1;

posted @ 2015-10-20 15:26  zqzdong  阅读(547)  评论(0)  编辑  收藏  举报