how to delete duplicate data as the example below, with X + +,
if SerialID and Code, have the same value, then the first data (viewed from date) must be deleted.
Iterate through records sorted in descending order, always skip the first occurrence of SerialId/Code and call delete() on all subsequent records with the same SerialId/Code.
Hi Edo Mas Suryatmo,
Yes. You can sort the table by serial id and delete from the second records like Maritin comments.
Please also refer this URL http://axinhd.blogspot.in/2012/03/deleting-duplicate-records-in-table.html