Mar 11, 2019 02:16 AM|Wei Zhang|LINK
According to your description, I have made a sample here. I suggest you that you could use Min( )to get the min date2 which has the same id, then you could delete the data in table whose date2 is lager than the min.
Here is the demo, I hope it could help you.
My date table:
DELETE FROM date
FROM date AS csq
It shows as below: