Search found 1 match

Go to advanced search

by Rajesh Jeganathan
Fri Apr 23, 2021 7:33 am
Forum: Oracle Discussion
Topic: How to Delete Duplicate Records ?
Replies: 3
Views: 53576

Re: How to Delete Duplicate Records ?

DELETE FROM Employees
WHERE rowid not in (SELECT MAX(rowid) FROM Employees GROUP BY First_name);

Go to advanced search