troubleshooting Question

Listing the number of duplicated records on an Oracle table

Avatar of CarlosScheidecker
CarlosScheidecker asked on
DatabasesOracle Database
4 Comments1 Solution415 ViewsLast Modified:

I have a table with:

- Name
- Title
- endDate
- Description
- cdate

Name, Title and endDate are the primary key. If one of them is different, than a record is inserted.

However, since date is a timestamp, if I have it some seconds before or after a new record is created.

What I need to know is the duplicated records were Name and Title are exactly the same.

Something like this would only work when you need to deduplicate the values from one field.
I have 2 fields that needs to be exact.

SELECT     tablefield, COUNT(tablefield) AS dup_count
FROM         table
GROUP BY tablefield
HAVING     (COUNT(tablefield) > 1)

I need to diplay the following results per row/tuple :
- Name, Title and the number of occurences that they show if there are duplicates.

If I can determine that the count of Name.Titles being the same is greater than 1, then I have a duplicated record. How can I do that in Oracle?

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros