On 9/5/2017 4:00 PM, Stephen Chrzanowski wrote:
select count(*) from teaInStock where "Last Used" IS NULL;
On behalf of Cecil, the fault in that logic is that count(*) returns the
number of rows in that table, not whether there is a hole "somewhere: Your
query will either return 1, or, 0.
What is this "hole" of which you speak? This query can very well report a
number other than 1 or 0.
count(*) returns the number of rows satisfying the condition in the WHERE clause; in this
case, the number of rows having NULL in "Last Used" column. In what way do you
believe this fails to satisfy the OP's requirements?
sqlite-users mailing list