Delete first 3 records and last two records as same day two locations should not be assigned to same id,id_seq,eid combination because it is wrong combination.
ID | ID_SEQ| TS_DT | EID | LOCATION_ID
123|1 | 10/10/2019 | hello | A123
123|1 | 10/10/2019 | hello | A123
123|1 |10/10/2019 | hello | W123
123|1 |11/10/2019 | hello |A123
124|1| 10/10/2019 | hello1 | S123
124|1| 10/10/2019 | hello1 | S123
124|2 | 10/10/2019 | hello1| A123
456|2| 11/12/2019 | msg | A123
456|2| 11/12/2019 | msg | S123