title: Query the row which with the maximum value on "cont" column
body: <p>Hey, I'm trying to query the words which have the maximul values in the cont columns. Ex: if the word "test1" has the value 5 in cont, and "test2" has 2, "test1" will be shown in first position. got it?</p>
  
  <p>so. Im trying to do it but it returns the following error:</p>
  
  <p>09-18 22:24:04.072: ERROR/AndroidRuntime(435): Caused by: android.database.sqlite.SQLiteException: misuse of aggregate function MAX(): , while compiling: SELECT word FROM words WHERE MAX(cont) ORDER BY cont desc</p>
  
  <p>Here is my method:</p>
  
  <pre><code>public List&lt;String&gt; selectMaxCont(){
     List&lt;String&gt; list = new ArrayList&lt;String&gt;();
     Cursor cursor = this.db.query(TABLE_NAME, new String[]{"word"}, "MAX(cont)", null, null, null, "cont desc");
     if(cursor.moveToFirst()){
         do{
     list.add(cursor.getString(0));
         }while(cursor.moveToNext());
     }
     if(cursor != null &amp;&amp; !cursor.isClosed()){
         cursor.close();
     }
     return list;
  </code></pre>
  
  <p>}</p>