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

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

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

导航