如何只显示重复数据，或不显示重复数据
显示重复：select * from tablename group by id having count(*)>1；不显示重复：select * from tablename group by id having count(*)=1；
本文共 191 字，大约阅读时间需要 1 分钟。
如何只显示重复数据，或不显示重复数据
显示重复：select * from tablename group by id having count(*)>1；不显示重复：select * from tablename group by id having count(*)=1；
转载于:https://www.cnblogs.com/Rainbow-G/p/4080021.html