As I understand the requirements, he wants to find out how many entries
(Not which entries) don't exist between the first ID (Assumed 1) and max ID
value.  So if he's got 3 rows, but max ID is 5, the result should be 2.

But I also suspect you're better in tune with the requirements, since I
suspect this had something to do with another thread that I barely was
paying attention to.

On Tue, Sep 5, 2017 at 4:05 PM, Igor Tandetnik <> wrote:

> 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?
> --
> Igor Tandetnik
> _______________________________________________
> sqlite-users mailing list
sqlite-users mailing list

Reply via email to