un-expected bug in Android SQLite

view story

http://stackoverflow.com – In my App, I was trying to save marks of student in SQLite Table, and show those in ListView, My App also have functionality of SORT orders, when I enter the marks of students 89, 78, 90, 100 respectivily and after this I want to sort the List in marks ascending order the name of student with 100 marks is at the top of the list and then the students having marks 78, 89, 90, apear in list one after other, why is this bug occuring? My DB schema is : public static final String COL_ID = "_id"; public static final String COL_NAME = "name"; public static final String COL_ADDRESS = "address"; publi (HowTos)