Wipro Question:

How to delete Duplicate row in table of Wipro?

Tweet Share WhatsApp

Answer:

SQL> delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name).

Download Wipro PDF Read All 35 Wipro Questions
Previous QuestionNext Question
Can you please explain the difference between interface and multiple interface?When do we use SQL Profiler in Wipro?