Systems Automation
A Blog of Automation and Administration Activities
Showing posts with label
SQL
.
Show all posts
Showing posts with label
SQL
.
Show all posts
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
Older Posts
Home
Subscribe to:
Posts (Atom)