Answers

Question and Answer:

  Home  Oracle Scenarios

⟩ How we remove duplicate rows in table?

select * from employee a where rowid not in(Select min(rowid) from employee b where b.emp_id = a.emp_id)

 145 views

More Questions for you: