Friday, June 25, 2010

Delete duplicate records from a table

delete from test a
where rowid <> ( select max(rowid)
from test b
where a.sno = b.sno
and a.sname = b.sname )

No comments:

Post a Comment