title: Android SQLite rawquery returns only first record
body: <p>My SQLite query returning only one record, However, the table has multiple rows</p>
  
  <pre><code>cursor=mydb.rawQuery("Select category from items;", null);
  </code></pre>
  
  <p>I have even tried <code>GROUP BY</code> but still wont work.</p>
  
  <p>I am new to SQLite, would appreciate any help. Thanks.</p>