> PS Note that it is count(X) and not count("X")
Count(X) and Count("X") are identical if X is a column in the table (or join)
from which you are counting, and X does not contain embeded spaces, special
characters, or other inanities. count(*) counts rows, and count('X') or
count(1) [or any other constant in place of 1] will also return the row count
(because you have provided a non-null value to be counted for each row).
In fact, count(expression) is exactly equivalent to sum(1) where expression is
not null, unless expression includes the keyword distinct.
---
() ascii ribbon campaign against html e-mail
/\ www.asciiribbon.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
