sql 分组查询 数据 大于2条的数据

select COUNT(Email) ,Email from tb_Mer_Accounts
Group by Email
having COUNT(Email)>1

posted on 2012-10-23 17:05  水行者  阅读(2778)  评论(0)  编辑  收藏  举报

导航