> SELECT AVG(a),COUNT(a) FROM test; > +--------+----------+ > > | AVG(a) | COUNT(a) | > > +--------+----------+ > > | 2.0000 | 1 | > > +--------+----------+ > > This is more or less the same you just did in fastbit.
And this is what i really meant ;): mysql> SELECT AVG(a),COUNT(*) FROM test; +--------+----------+ | AVG(a) | COUNT(*) | +--------+----------+ | 2.0000 | 2 | +--------+----------+ > > SELECT AVG(a),COUNT(a) FROM test; > +--------+----------+ > > | AVG(a) | COUNT(a) | > > +--------+----------+ > > | 2.0000 | 1 | > > +--------+----------+ > > This is of course a bit different as COUNT on a specific column doesn't > count the NULLs of this column. > _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
