select * from table where exists(select 字段名 from table group by 字段名 having count(字段名)>1) 转载于:https://www.cnblogs.com/wifi/archive/2011/12/12/2285116.html