title: How to write A Range Query in Sqlite Android?
body: <p>Suppose I have a table with 2 fields: <code>Number</code> and <code>Description</code>, I want to get the description from a number I request.</p>
  
  <p>For example: I request the number 22. But in the database, there is no row matching the value 22.</p>
  
  <p>I need to write a query to get the values <strong>ranges between +5 and -5</strong> of that number and <strong>getting the nearest data</strong> present in the database. That is, I want to get <code>"rty"</code> as the description when I request 22.</p>
  
  <pre><code>Table
  
  Num     |Description
  --------+-----------
  25      |ASD
  18      |wert
  21      |rty
  </code></pre>