sqlite count rows code example

Example 1: android sqlite get rows count

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

Example 2: sqlite select count limit

SELECT
	column_list
FROM
	table
LIMIT row_count;