Finn duplikater i en tabell

Denne er grei når man skal finne dupliserte verdier i en tabell:
SELECT felt,
COUNT(felt) AS duplikater
FROM tabell
GROUP BY felt
HAVING ( COUNT(felt) > 1 )

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.