Saved Bookmarks
| 1. |
How To Eliminate Duplicate Records Except One |
|
Answer» ANSWER : DELETE FROM TZCHC TD1 WHERE HOLIDAY_DATE<> (SELECT MIN (HOLIDAY_DATE) FROM TZCHC TD2 WHERE TD1.LONG_DESC = TD2.LONG_DESC AND TD2.LONG_DESC = 'CHRISTMAS DAY’); |
|