SELECT mp, fullname, COUNT(mp) AS Expr1
FROM Users
GROUP BY mp, fullname
HAVING (COUNT(mp) > 1)
查找手机号有两个以上的用户的姓名
SELECT mp, fullname, COUNT(mp) AS Expr1
FROM Users
GROUP BY mp, fullname
HAVING (COUNT(mp) > 1)
查找手机号有两个以上的用户的姓名
转载于:https://www.cnblogs.com/asiarice/p/7998192.html