求一条sql语句（很简单）

select * from table where name in(select distinct(name) from table group by name having count(*)>1)

select name from 表名
group by name
having count(name)>1
这样只显示name列,address列不显示出来.要是想两列都显示要分两步

select name into #a from 表名
group by name
having count(name)>1

select * from 表名
where name in (select name from #a)

select * from （表的名字）z
where exists (select 1
from (select name, count(*) nn
from （表的名字）zz
group by zz.name)
where nn > 1 and zz.name=z.name)

在存在大量数据时候，用in的效率会很低

select a,ad1
from table1
group by a,ad1
having count(*)>1;

公布一下标准答案：

如果条件是过滤掉CEF，那么
select * from Atable where name not in(C,E,F)--这里过滤多少都行

如果是选择name出现次数大于1的，那么
select * from Atable where name in(select name from Atable group by name having count(*)>1)

select a.