Hi Ranjit,
You can try this
[code=oracle]
delete from Employee
where empno ='emp01'
AND name ='ranjit'
AND salary = 10000.50
AND rownum = 1
[/code]
Run this query one less then the no of records.
In this example there are 6 entries of the same so you have to run this query 5 times
Regards
Akhilesh...
Leave a comment: