antonis_wrx blog
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).
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)