Thursday, September 24, 2009

Find Duplicate records in Oracle

SELECT COL_TO_CHECK, COUNT(COL_TO_CHECK)
FROM TABLE_NAME
GROUP BY COL_TO_CHECK
HAVING COUNT(COL_TO_CHECK) > 1
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)