chgn01 (8/31/2015)
If change count(1) to SUM(id), it return NULL and why?
count(1) returns the number of rows in the table which is zero.
sum(id) returns the arithmetic total of the known values in the id columns. since there are no known values the result is unknown (null).
Don Simpson