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

Reply via email to