select id from table1 where id in(select id from table1 group by id having count(id)>1) ---- 来自jb51.cc
