查询同一个表中重复的字段

//查询同一个表中某个字段重复的sql:
select tmp._name from (select count(e._name) c,e._name from extractinfo e group by e._name) tmp where tmp.c >= 2

//查询两个结构相同表中相同的name
select a._name from extractinfo1 a where a._name in (select b._name from extractinfo2 b );

//去掉同一个表中相同的name

select distinct _name from extractinfo