// 查询用户表 手机号对应不只一个用户的手机号列表 跟数量 (项目在运营后晚上偶尔出现 多个用户对应一个手机号的情况)
select mobile,count(mobile) from go_member where mobile!='' group by mobile having count(mobile)>1
//多个 排序条件 排序
select * from go_member order by a1,a2 desc
注:排序条件是 按a1升序,a2降序(先按a1升序排列,若有a1相同的再按a2降序排列)
select * from go_member order by a1 desc,a2 desc
注:排序条件是 按a1降序,a2降序