On 9/15/2015 2:04 PM, John McKown wrote: > sqlite> select count(a) from x;
Better still: select exists (select 1 from x); The difference is that the version with count() always scans the whole table, while the latter stops at the first record - which is good enough if you only need to check for existence, and don't actually need the count. -- Igor Tandetnik
