HI , JUST TRY TO THIS

alter table <TABLENAME> add gid timestamp

delete from <TABLENAME> where gid not in(select max(gid) from <TABLENAME> group by Field1,Field2)

alter table <TABLENAME> drop column gid

Note: Field1,Field2 are...