SQLITE: Count column values

Question

I have some code like this:

    public void gameOverCheck() {
    SQLiteDatabase database = this.getWritableDatabase();
    database.execSQL("SELECT " + COL_ROLE + " COUNT");
    database.close();
}

in android. And would like to count the values of COL_ROLE (which has one of two possible values (mafia, civilian)). So if the number of Mafia >= Civilian game = mafias win. If Mafias = 0, game = civilian won. I am struggling with the SQL command to do the first part, am I supposed to group the values?

Helmut G. · Accepted Answer · 2017-04-10 17:11:25Z

1

Try this:

Cursor mCount= db.rawQuery("select count(*) from your_table where " + COL_ROLE + " = 'mafia'", null);
mCount.moveToFirst();
int count = mCount.getInt(0);
mCount.close();`

edited Apr 10, 2017 at 17:11

answered Apr 10, 2017 at 16:54

Helmut G.

365 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Tuss Ramzan Over a year ago

Thank you :), what do you mean by it will be stored in the Count variable? How would I retrieve this variable and say, store it into a String or an Int?

Helmut G. Over a year ago

Sorry, I forgot that the execSql method doesn't return any data - I've updated my answer :-)

Tuss Ramzan Over a year ago

Thank you :) So I now have Cursors which count both the Mafias and Civilians using your code, stored in countM and countC respectively. I need an if else statement now to compare the two ints and I should be set! Thanks!

Collectives™ on Stack Overflow

SQLITE: Count column values

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related