数据库sql语句查询-查询重复数据

SELECT
    mob,       //根据某个字段查询重复
    count(*) AS count
FROM
    ****表    //查询的表
GROUP BY
    mob
HAVING
    count > 1;