查询 userorgz 表,统计出有手机号码重复的手机号码以及重复个数,并根据重复数量降序排序且手机重复个数必须大于 1
select mobilephone, count(*) from userorgz group by mobilephone having count(*)>1 order by count(*) desc;