| |||||
|
Given a table which contains some rows with dupl More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...) Given a table which contains some rows with duplicate keys, how would you remove the duplicates?
create temporary table with same table structure and then create unique index on this temporary table with option ignore_dup_row.
(Continued on next question...)
Other Job Interview Questions
|
||||