查询出user表中mobile重复的条数
select * from user where mobile in (select mobile from user group by mobile having count(*) > 1)
查询出user表中mobile的重复次数
select count(mobile) as num,mobile from user group by mobile having count(*)>1 order by mobile desc
查询出user表中mobile重复的条数
select * from user where mobile in (select mobile from user group by mobile having count(*) > 1)
查询出user表中mobile的重复次数
select count(mobile) as num,mobile from user group by mobile having count(*)>1 order by mobile desc