-- 查询表中USER_MOBILE字段重复的数据
SELECT USER_MOBILE, count(USER_MOBILE) FROM user
GROUP BY USER_MOBILE
HAVING count(USER_MOBILE) > 1
常用Sql
最新推荐文章于 2024-09-23 09:14:08 发布
-- 查询表中USER_MOBILE字段重复的数据
SELECT USER_MOBILE, count(USER_MOBILE) FROM user
GROUP BY USER_MOBILE
HAVING count(USER_MOBILE) > 1