I Have a table in which there is a chance of duplicate rows. Can you please tell me how to eliminate the dup;licate records?
Question: I Have a table in which there is a chance of duplicate rows. Can you please tell me how to eliminate the dup;licate records?
Question:I Have a table in which there is a chance of duplicate rows. Can you please tell me how to eliminate the dup;licate records?
AnswerUse primary key If column is like Id or no..Alternate way is you can apply unique constraint on column.. hope u hv cleared ur doubts
By:chaitanya
Date:chaitanya.hublikar194@gmail.com
Question:I Have a table in which there is a chance of duplicate rows. Can you please tell me how to eliminate the dup;licate records?
AnswerDeletion of duplicate records:
delete from emp a where a.rowid > (select min(b.rowid)
from emp b where a.rowid=b.rowid)
or
delete from table t1 where t1.rowid < (select max(t2.rowid) from table t2 where t2.<common column_name> = t1.<common column_name>)
By:Bojja Ravi Kumar
Date:ravikumar.bojja@gmail.com
I Have a table in which there is a chance of duplicate rows. Can you please tell me how to eliminate the dup;licate records?
Post Your Answers
Related Links
Question:I Have a table in which there is a chance of duplicate rows. Can you please tell me how to eliminate the dup;licate records?
