How to delete duplicate rows without using group by or self join , that is without using below queries.
Delete from table where rowid not in ( select max(rowid) from table group by column);
Or
Delete from table x where rowid not in(select max(rowid) from table y where x.col = y.col)
Thanks in advance
Dinesh Kumar