DELETE DUPLICATE ROWS IN TABLE QUERY

1.delete from jeg where rowid not in (select max(rowid) from jeg group by n);

2.delete from ela where rowid not in (select max(rowid)from ela group by E_id);
 

   EX:=

   DELETE FROM <TABLENAME> WHERE ROWID NOT IN (SELECT MAX(rowid)from <TABLENAME> group by (column_name))