mysql 数据表中查找重复记录
SELECT
open_id,
ip,
Count(*)
FROM
user
WHERE
type = 'readypro'
GROUP BY
ip
HAVING
Count(*) > 1
ORDER BY
Count(*) DESC;
mysql 数据表中查找重复记录
SELECT
open_id,
ip,
Count(*)
FROM
user
WHERE
type = 'readypro'
GROUP BY
ip
HAVING
Count(*) > 1
ORDER BY
Count(*) DESC;