select * from cwz2009 where id not in (select id from cwz2009 group by name ); select * from cwz2009 group by name having count(*)>1 ;