mysql 数据表中查找重复记录

mysql 数据表中查找重复记录

SELECT
    open_id,
    ip,
    Count(*)
FROM
  user
WHERE
    type = 'readypro'
GROUP BY
    ip
HAVING
    Count(*) > 1
ORDER BY
    Count(*) DESC;