Select * from fa_user
where mobile<>” and mobile in (select mobile from fa_user group by mobile having count(mobile) > 1);
关注公众号,了解更多it技术(it问答网)
徐多蔚APP开发,合肥物联网项目开发,合肥网络开发,合肥项目高端定制,企业oa开发,合肥小程序开发,合肥公众号开发,合肥网络安防 – 徐多蔚 xuduowei
联系方式[微信]:徐多蔚15309695130 感恩有您的陪伴,我们用心服务每一位客户 – 徐多蔚 xuduowei
Select * from fa_user
where mobile<>” and mobile in (select mobile from fa_user group by mobile having count(mobile) > 1);