How to sort sqlite database in android

Question

I need to display list of 10 best scores. I used this code to get the data and put it in a arraylist

private ArrayList<String> getData() {
    String[] columns = {DbHelper.COL_NAME, DbHelper.COL_SCORE};
    Cursor c = db.query(DbHelper.TABLE_NAME, columns, null, null, null, null, DbHelper.COL_SCORE, "10");
    int nameCol = c.getColumnIndex(DbHelper.COL_NAME);
    int scoreCol = c.getColumnIndex(DbHelper.COL_SCORE);
    for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()) {
        scoresList.add(c.getString(nameCol) + " " + c.getString(scoreCol));
    }

    return scoresList;
}

The only problem that its ordered from the lowest score to the highest, and i need it reversed.

Add an ORDER BY Score DESC clause (by default, the ORDER BY statement operates as if you specified ASC) — Phantômaxx
– Phantômaxx, Commented Jun 10, 2017 at 13:27

Priyank Patel · Accepted Answer · 2017-06-10 13:31:21Z

1

Try with below query...

Cursor c = db.query(DbHelper.TABLE_NAME, columns, null, null, null, null, DbHelper.COL_SCORE +" DESC", "10");

answered Jun 10, 2017 at 13:31

Priyank Patel

12.4k8 gold badges69 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to sort sqlite database in android

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related