title: How to get the first column data in sqlite database?
body: <p>I am trying to get the first column like below sql but my code show error. </p>
  
  <pre><code>SELECT subject FROM setting WHERE rowid=1
  
      public void getSetting(){
      result = "";
  
  SQLiteDatabase db = myDbHelper.getReadableDatabase();   
  
  Cursor c = db.query(true, "setting", new String[] {"subject", "language", "selection"}, "row=1", null, null, null, null, null);
  
      for(c.moveToFirst();!(c.isAfterLast());c.moveToNext()){
  
  result = result + c.getString(0);
  result = result + c.getString(0);
      result = result + c.getString(0);
      }
      if (c.getCount() == 0)              
      result = result + "result not found";   
  
  c.close();      
  db.close();         
  myDbHelper.close(); 
  
  }             
  </code></pre>