query per contare i duplicati in una tabella

[optime]

SELECT COUNT(*) FROM (SELECT chiave FROM Mytab GROUP BY chiave HAVING count(*)>1) T1