Question

There is a column C1 in a table T1. The following two statements: SELECT COUNT(*) FROM T1; and SELECT COUNT(C1) from T1; are giving different outputs. what may be the possible reason?

Answer 1

There may be a null value.