1.如何只显示重复数据,或不显示重复数据
显示重复:select * from tablename group by id having count(*)>1
不显示重复:select * from tablename group by id having count(*)=1
显示重复:select * from tablename group by id having count(*)>1
不显示重复:select * from tablename group by id having count(*)=1