SELECT
*
FROM
表
WHERE
idIN ( SELECT hotspot_id FROM 表GROUP BY id HAVING COUNT ( id) > 1 )
ORDER BY
id;
SELECT id, count(id) FROM 表 GROUP BY id HAVING count(id) > 1;
WITH d AS (
SELECT id
FROM 表
GROUP BY id
HAVING count(id) > 1)
SELECT p.*
FROM 表 p
JOIN d ON (d.id= p.id)
ORDER BY p.id;