android - ORDER BY 不对记录进行排序

Question

我正在尝试按顺序从较高值到较低值获取记录，但排序没有发生，我正在随机获取记录。

这是我的代码，请告诉我哪里出错了:

public void fetchTopRecords() {

    int i = 0;

     String where = "SELECT * FROM " + DATABASE_TABLE_2 + " ORDER BY "
     + COL_C + " ASC LIMIT 6";
     Cursor c = db.rawQuery(where, null);
    if (c != null) {
        if (c.moveToFirst()) {
            do {
                String pckname = c.getString(COL_A);
                array_pck.add(pckname);
                int marks = c.getInt(COL_C);
                i++;
            } while (c.moveToNext());
        }
    }

Answer 1

使用下面的代码即可工作:

public void fetchTopRecords() {
   String where = "SELECT * FROM " + DATABASE_TABLE_2 + " ORDER BY "
    + COL_C + " DESC LIMIT 6";
   Cursor c = db.rawQuery(where, null);
   if (c != null) {
       if (c.moveToFirst()) {
          do {
             String pckname = c.getString(COL_A);
             array_pck.add(pckname);
             int marks = c.getInt(COL_C);                
          } while (c.moveToNext());
       }
   }