CODE EXAMPLE FOR SQL

android sqlite get rows count

SQLiteDatabase db = this.getReadableDatabase();
long count = DatabaseUtils.queryNumEntries(db, TABLE_NAME);
db.close();