Question Detail

Use this method in your code

to get descending order List

// Getting All Table Data
public List<DataClass> getAllData() {
    List<DataClass> dataList = new ArrayList<DataClass>();
    // Select All Data Query in descending order
    String selectQuery = "SELECT  * FROM " + TABLE_ALBUMS+ " ORDER BY " + KEY_ID + " DESC";
    SQLiteDatabase db = this.getWritableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);

    // looping through all rows and adding to list
    if (cursor.moveToFirst()) {
        do {
            DataClass album = new DataClass();
            album.setID(Integer.parseInt(cursor.getString(0)));
            album.setAlbumName(cursor.getString(1));
            album.setImagespathString(cursor.getString(2));
            album.setDescription(cursor.getString(3));
            album.setCaption(cursor.getString(4));
            album.setMemoryDate(cursor.getString(5));
            // Adding album to list
            dataList.add(album);
        } while (cursor.moveToNext());
    }
    // return Data list
    return dataList;
}