1. 查询之group by,having,count(1)
nickname,username作为唯一性,查询表中相同的数据有几条
select nickname,username,count(1) from t_user group by nickname,username having count(1)>1;
nickname,username作为唯一性,查询表中相同的数据有几条
select nickname,username,count(1) from t_user group by nickname,username having count(1)>1;