On 5/9/2018 4:19 PM, Cecil Westerhof wrote:
I have a table where I use 'unused' to signify that a record is not yet used. I want to know the number of unused records (but only if there are unused records) and the total number of records.
Something like this perhaps: select count(*) Total, sum(totalUsed = 'unused') NotUsed from quotes; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
