Delete duplicate records without using "rowid"

[Barbie]

Jaiprakash,
we need to delete only one of those duplicated rows.
but that delete statement will deletes both.