On Mon Aug 04, 2014 at 06:04:53PM +0200, RSmith wrote: > CREATE TABLE x(id INTEGER); > > SELECT Count(*) FROM x; > | 0 | > > --vs.-- > SELECT Count(*) FROM x GROUP BY id; > (No Results) > > > Paints a clear picture I hope!
Yes it does, thanks. I guess I still find the combination of COUNT without a GROUP BY to be unintuitive, but at least I know why now. -- Mark Lawrence _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
