title: How to retrieve row values on behave of column distinct value in SQLite?
body: <p>I have a table like this</p>
  
  <pre><code>  User-ID     RANK        Dept     LEVEL-PASSED         
   -------     ------       -----     --------  
      1          950         TECH        54
      2          525         TECH        32
      3          379         TECH        23
      4          955         AGRI        54
      5          956         AGRI        54
      6          558         AGRI        32
  </code></pre>
  
  <p>On behalf of distinct values in column "level passed" , i want to retrieve the Dept Value with it.</p>
  
  <p>How can i do it in sq-lite android.</p>
  
  <pre><code>Cursor cursor = db.query(true, TABLE_NAME, new String[] { LEVEL-PASSED}, null, null, null, null, null, null);
  </code></pre>
  
  <p>This retrieves distinct level passed values i.e 54,32,23 but with it i also want to retrieve dept values. </p>
  
  <p>expected result would be like this.</p>
  
  <pre><code>Dept     LEVEL-PASSED 
  TECH        54
  TECH        32
  TECH        23
  </code></pre>
  
  <p>I do not care if Dept has TECH or AGRI. The distinct should just bring some dept value with it.</p>