查询重复数据

 select username from xi group by username  having count(*) > 1

原文地址:https://www.cnblogs.com/bingyublog/p/9295530.html