On 2017/01/25 6:15 PM, Simon Slavin wrote:
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.
Shame on you Simon, you made me feel stupid! I was expecting a smart
explanation of some special SQL standard feature like "It uses the first
column" or "it totals all the suitable columns" or some such that I
wasn't aware of. Thanks for clearing it up!
Ryan
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
