查询mysql重复数据的sql

SELECT
phone,
count(*) AS count
FROM
test_user
GROUP BY
phone
HAVING
count > 1;