只显示重复数据，或不显示重复数据

如何只显示重复数据，或不显示重复数据

显示重复：select * from tablename group by id having count(*)>1；
不显示重复：select * from tablename group by id having count(*)=1；