Tag Info

New answers tagged

3

You explain: I get result 1453 only when all items in column attributeY are empty for 1453. But that's incorrect. Bold emphasis mine. The aggregate function count returns (per documentation): number of input rows for which the value of expression is not null The same is true for SQLite (per documentation): The count(X) function returns a ...


2

It works for me with a similarly created structure. You didn't provide DDL and INSERTs for your table so I just made up a shorter one that should have the same effect: $ sqlite3 test.db SQLite version 3.8.8.3 2015-02-25 13:29:11 sqlite> CREATE TABLE test(x integer, y text); sqlite> INSERT INTO test(x, y) VALUES (1, ''); sqlite> INSERT INTO test(x, ...



Top 50 recent answers are included