Good Day,
I have a table with about 40,000 rows and I’m trying to find duplicate rows – rows in which 5 columns (that should have been the primary key) are identical.
I tried the following query:
select a,b,c,d,e
from
tableA
minus
select distinct a,b,c,d,e
from
tableA
To my surprise, it returned no rows even though I know that there are over 100 rows with these identical columns.
Any ideas?
Thanks,
Dan
I have a table with about 40,000 rows and I’m trying to find duplicate rows – rows in which 5 columns (that should have been the primary key) are identical.
I tried the following query:
select a,b,c,d,e
from
tableA
minus
select distinct a,b,c,d,e
from
tableA
To my surprise, it returned no rows even though I know that there are over 100 rows with these identical columns.
Any ideas?
Thanks,
Dan