Re: Deleting pseudo-duplicates...
Vicente, A simple & fast way is via an exclusion join: delete t1 from tbl t1 left join tbl t2 on t1.value=t2.value and t1.id>t2.id where t2.id is not null; To understand how that works, notice that the query select t1.id from tbl t1 left join tbl t2 on t1.value=t2.value and t1.id>t2.id where t
Deleting pseudo-duplicates...
Hello, I have a table with this values: idvaluetime 112200704042112 212200704042120 314200704042125 414200704042131 517200704042140 614200704042143 720200704042145 820200704042148 I want to
