学步园

select * from table where  exists(select 字段名 from table group by 字段名 having count(字段名)>1)