Android: ORDER BY in database query

Asked Mar 25 '16 at 05:35

Active Mar 25 '16 at 05:35

Viewed 43 times

Let's say I have these values in my database, column SCORE { 70, 90, 100 , 110, 80 } Why does when i use this code,

Cursor cursor = database.query(sqliteHelper.TABLE_SCORES, allColumns, null, null, null, null, sqliteHelper.SCORE + " DESC");

It was sorted like { 90,80,70,110,100 }

I think it sorts like that because 9>1?? How can I solve this?

asked Mar 25 '16 at 05:35

camille

1

what is datatype of column `score`?? – ELITE Mar 25 '16 at 05:39
3

Cast the column to a numeric type: `"CAST(" + sqliteHelper.SCORE + " AS INTEGER) DESC"` – Mike M. Mar 25 '16 at 05:42
1

Mike M. that solved the problem. Thanks!! – camille Mar 25 '16 at 06:50

0 Answers0