Thursday, July 8, 2010

Find duplicate entries in oracle database

In order to find column values that occur more than once in a table:

SELECT column, COUNT(column)
FROM table
GROUP BY column
HAVING COUNT(column) > 1

(where column is the field of interest).

No comments: