IS

select last_name, manager_id from employees 
where manager_id IS NOT NULL;
# manager_id가 NULL 값이 아닌 것만 
Bash
복사

select last_name, manager_id from employees 
where manager_id IS NULL;
# manager_id가 NULL 값인 것만 
Bash
복사