Wipro Question:
How to delete Duplicate row in table of Wipro?
Answer:
SQL> delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name).
| Previous Question | Next Question |
| Can you please explain the difference between interface and multiple interface? | When do we use SQL Profiler in Wipro? |