performance problem

[Franz Z.]

SELECT *
FROM test
WHERE id
IN (

SELECT id
FROM test
GROUP BY id
HAVING count( id ) >1
)

SELECT ID, COUNT(*) AS zaehler
FROM table
GROUP BY ID
HAVING zaehler > 1

Grüße, Franz Z.