Removing duplicate rows from sqlite table

db.execSQL("delete from TABLENAME where rowid not in (select min(rowid) from TABLENAME group by COLOUMNNAME);");