MSDN documentation states:
COUNT(*) returns the number of items in a group. This includes NULL values and duplicates.
How can you have a null value in a group? Can anyone explain the point they're trying to make?
See Question&Answers more detail:os