I have a table with syn_trans with below cols:
There is no unique/primary key on the table.
A row exists in table with below values:
INSERT INTO syn_trans VALUES(60175,'AccountOverview',0,'Signon','StepGp');
Two days later I again execute the same insert statement and now there exists two records for the ID=60175
I want to retrieve the entry with latest timestamp or in other words I want to delete the entry for this ID which I added second time.
Plz provide the SQL for this.
Thanks in advance.