在android sqlite中删除行并只保留最后一个值

SQLiteDatabase db = this.getWritableDatabase();

String tableName = "your_table_name";
String columnName = "your_column_name";
String condition = "your_condition"; // 设置删除条件

String deleteQuery = "DELETE FROM " + tableName + " WHERE " + columnName + " NOT IN (SELECT " + columnName + " FROM " + tableName + " ORDER BY " + columnName + " DESC LIMIT 1 OFFSET (SELECT COUNT(*) FROM " + tableName + ") - 1) AND " + condition;

db.execSQL(deleteQuery);

db.close();