On 25 Jan 2017, at 4:14pm, R Smith <[email protected]> wrote: > Maybe I'm misunderstanding some fundamental principle, but I don't see how > TOTAL(count) is equivalent to TOTAL(*)? COUNT(some_field_name) and COUNT(*) > might be equivalent, but I'm wondering how total would know which column you > need the total of when using * ?
Nope. I had a bad day and confused the two functions. Please ignore my earlier suggestion. Thanks for pointing it out, R. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
