2017-09-05 21:55 GMT+02:00 Igor Tandetnik <i...@tandetnik.org>: > On 9/5/2017 3:45 PM, Cecil Westerhof wrote: > >> It is not very important, but I am just curious. I need to know how many >> records are not yet used. I do that with: >> SELECT COUNT(*) - COUNT("Last Used") AS "Not Used" >> FROM teaInStock >> >> Is that the correct way, or is there a better way? >> > > Why not be explicit about what you are trying to do? > > select count(*) from teaInStock where "Last Used" IS NULL;
You are completely right: that is a much better statement. (Blushing.) -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users