Quick way to find duplicates in DB

Anybody know a quick SQL query

[surfgatinho]

I need to make a field in a DB unique, however I can't because there are duplicate entries.

Does anybody know an SQL query I can run that will find these duplicates so I can remove them.

Thanks in advance,
Chris

[kamakaze]

SELECT field,
COUNT(field) AS NumOccurrences
FROM table
GROUP BY field
HAVING ( COUNT(field) > 1 )

That should do the trick.

[surfgatinho]

Thanks kamakaze, you're a star!
Had forgotten all about HAVING clauses

[badone]

Thanks for this topic guys. I've been looking for this.

Cheers,
BAD