Question

There is a column Salary in a Table EMPLOYEE. The following two statements are giving different outputs. What may be the possible reason ?

SELECT COUNT(*) FROM EMPLOYEE;

SELECT COUNT( SALARY) FROM EMPLOYEE;

Answer 1

If there are null values in the salary column alone, then COUNT function will not count those records.