get the sum of specific column sqlite android code example
Example: get sum sqlite android
Cursor cursor = db.rawQuery("SELECT SUM(" + DbHelper.CART_TOTAL + ") as Total FROM " + DbHelper.CART_TABLE, null);
if (cur.moveToFirst()) {
int total = cursor.getInt(cursor.getColumnIndex("Total"));// get final total