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;

Igor Tandetnik

sqlite-users mailing list

Reply via email to