db.execSQL("delete from TABLENAME where rowid not in (select min(rowid) from TABLENAME group by COLOUMNNAME);");
Showing posts with label Removing duplicate rows from sqlite table. Show all posts
Showing posts with label Removing duplicate rows from sqlite table. Show all posts
Saturday, January 26, 2013
Removing duplicate rows from sqlite table
db.execSQL("delete from TABLENAME where rowid not in (select min(rowid) from TABLENAME group by COLOUMNNAME);");
Subscribe to:
Posts (Atom)