NULL is not determinate value and is not counted when the COUNT function is used with the DISTINCT keyword For instance, if you SELECT DISTINCT MANAGER_ID from EMPLOYEES; you will get 19 rows with NULL among them. However, if you do SELECT COUNT(DISTINCT MANAGER_ID) from EMPLOYEES; you will get […]