What does COUNT ignore?
A table Employee has 10 rows. The manager_id column is NULL for 3 of
them.
sql
SELECT COUNT(*), COUNT(manager_id) FROM Employee;
What does this return?
A table Employee has 10 rows. The manager_id column is NULL for 3 of
them.
sql
SELECT COUNT(*), COUNT(manager_id) FROM Employee;
What does this return?