Nidhi G (12/24/2012)

---

Hi,

I have a table with syn_trans with below cols:
(
Id integer(10),
Name varchar2(100),
seq_no integer(10),
seq_name varchar2(100),
gp_name varchar2(100)
)

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.

Nidhi G (12/24/2012)

---

How do I delete one entry then?

delete t from 
(
select ROW_NUMBER() over (partition by Id  order by Id  ) as rank1,* from  syn_trans) t 
where t.rank1 <> 1