On 2017/01/25 1:36 PM, Simon Slavin wrote:
On 25 Jan 2017, at 5:13am, Jeffrey Mattox <[email protected]> wrote:
(1) SELECT TOTAL(count) as grandTotalCount FROM History
Please try replacing TOTAL(count) with TOTAL(*). Nothing to do with your
question but it may lead to faster results with less processing.
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 * ?
(I suppose I could test it when I get home, but was hoping someone may
have the quick answer...)
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
