去除重复语句SQL

表 table1
字段， a ,b,c,d,e

查询出那个e字段有多个，并且a字段都为F

select a,e from table1 group by a,e having  a = 'F' and count(e)>1;

结果：

a          e
F          55

去除重复字段

select * from table1 where e in (select e from table1 group by e having  count(*)>1);

结果

a      b      c     d      e
F      null   1    2      55