How to Delete Duplicate Data in Table.

excuse me,

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.

thank you.
edo.

serialId date code
12 1/12/2014 RM
13 1/10/2014 RM
12 1/13/2014 RM
12 1/14/2014 ASM

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

Thanks,

Hari