Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
arngue
Contributor III
Contributor III

How to find wich PK have duplicates

Hi,

I've been searching, but i don't need to know how many duplicates are, i've already know this. I need to find wich are the duplicated ones to find why is getting duplicated.

I have a very large table with 66246 rows and only one duplicate, anyone know how to find it?. tring with EXCEL crashes...

1 Solution

Accepted Solutions
achettipalli
Creator
Creator

Hi!

It sounds contradicting when Primary key has duplicates. However to know those duplicates one method could be:

=Aggr(If(Count(column)>1,1,0),column)

Good luck!

Avinash

View solution in original post

1 Reply
achettipalli
Creator
Creator

Hi!

It sounds contradicting when Primary key has duplicates. However to know those duplicates one method could be:

=Aggr(If(Count(column)>1,1,0),column)

Good luck!

Avinash