I have a table, having 100 records and primary key column.
Now i want to upload 10 more records.before start importing data i disable primary key and import the records .
After import when i enable primary key , i am having error msg
some records r dulicate.
Now with out any query is there is any way to get dulpicate records?
Thanks in advcane!!
You need to use an inner-join query to pull out the duplicate records and get some decisions about (a) removing the duplicates; of (b) create new entries for the duplicate (so that their entries are unique).
This depends on the business rules, needs and requirements.
The inner-join query on your table would look something like this:
(select min(rowid) from your_table B
b.key1 = a.key1
b.key2 = a.key2
where in this example, key1 and key2 are the 2 primary keys in your_table. If you have more PK, then add them to the sub select query.
I hope this helps you to find the duplicates.