title: Deleting specified number of rows from SQLite database
body: <p>I am trying to remove 6 rows from the database using the following statement but I get the error shown below.</p>
  <pre><code>getWritableDatabase().execSQL(&quot;DELETE FROM tblname ORDER BY _id ASC LIMIT 6;&quot;);
  </code></pre>
  <p>Error:</p>
  <blockquote>
  <p>Caused by: android.database.sqlite.SQLiteException: near &quot;ORDER&quot;: syntax error: DELETE FROM tblname*</p>
  </blockquote>
  <p>I tried reformatting the SQL in different ways but couldn't get it to work. What am I missing?</p>