title: Android SQLite Limit and Offset with date desc for sms
body: <p>Hi I'm trying to get the last 30 sms messages which works fine if I do this</p>
  
  <pre><code>Cursor c = contentResolver.query(uri, projection, null, null, "date desc limit 30 offset 0");
  </code></pre>
  
  <p>However, as I scroll my listview I'd like to list more messages so the next query should get me the next 30 sms messages but the ones that are slightly older than the first ones</p>
  
  <p>I tried this but it returns 0 results which I guess makes sense but I can't figure out how to get the next 30</p>
  
  <pre><code>Cursor c = contentResolver.query(uri, projection, null, null, "date desc limit 30 offset 30");
  </code></pre>
  
  <p>Thank you for any help and I hope what I'm asking is clear basically the first query gets me the last 1-30 rows and then the next query I'm trying to get the last 30 rows right before the first query</p>