...
Delete record from ss_order_call_date, check for the time gap between records, delete the record from the largest gap to latest (for example if 2021-9-25 07:15:02 , the next timestamp is 2021-9-26 00:00:00, which is suppose each time gap within 5mins)
| Panel | |||
|---|---|---|---|
| |||
| |||
delete from ss_order_call_date where last_call_date > '2021-09-25 07:15:02' |
...