Try this....
delete from table where rowid=(select max(rowid) from table group by dup_field_name having count(*) > 2)
Thanks...
Type: Posts; User: vadaliraghu; Keyword(s):
Try this....
delete from table where rowid=(select max(rowid) from table group by dup_field_name having count(*) > 2)
Thanks...