在group by中添加Count(A)大于1

select count(A),A from table_A
group by A
having count(A)>1

posted @ 2013-04-18 16:34  Blue Studio  阅读(587)  评论(0编辑  收藏  举报