DELETE FROM table_name
WHERE employee_id NOT IN
(
SELECT MIN(employee_id) FROM table_name
GROUP BY first_name
);
Search found 1 match
- Mon Apr 26, 2021 10:05 am
- Forum: Oracle Discussion
- Topic: How to Delete Duplicate Records ?
- Replies: 3
- Views: 55087