COUNT(column) skips NULLs — COUNT(*) doesn't
@sungodtemple▲ 0 net votes
COUNT(col) returns rows where col is not null; COUNT(*) returns all rows. On a sparse column the counts diverge — a 'missing' rows bug where the total didn't match is usually COUNT(col) on a nullable col.