尝试一下.

DELETE tbl1 FROM new_table tbl1, new_table tbl2 WHERE tbl1.date < tbl2.date AND tbl1.value = tbl2.value;

尝试之前，请复制数据.

Copy your data before you try.