What's the difference between
COUNT(CASE WHEN [Column A] = ____ THEN 1 END
COUNT(CASE WHEN [Column A] = ____ THEN 1 ELSE 0 END?
I've been using the former and I haven't seen the difference thus far; what is the reason for adding the
ELSE 0 - are there situations where SQL Server will incorrectly count?