Deleting specified number of rows from SQLite database

Question

I am trying to remove 6 rows from the database using the following statement but i get the error shown below

getWritableDatabase().execSQL("DELETE FROM tblname ORDER BY _id ASC LIMIT 6;");

Error: Caused by: android.database.sqlite.SQLiteException: near "ORDER": syntax error: DELETE FROM tblname

I tried reformatting the SQL in different ways but i couldn't get it to work. What am i missing? Thanks a lot for your help

Answer 1

DELETE FROM tblname WHERE `_id` IN (SELECT `_id` FROM tblname ORDER BY `_id` ASC LIMIT 6)

I think your problem may have been quoting the _id, though.