id columnA 1 black 2 red 3 red 4 green 5 red 6 black 7 white
long count = DatabaseUtils.longForQuery(db, "SELECT COUNT(*) FROM mytable WHERE columnA = '" + "black" + "', null);
select type, count(type) from table group by type;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)