distinct

1:select distinct department_id from employees;

2:select distinct department_id from employees where department_id is not null;

3:select distinct department_id from employees

where department_id not in(100);

4:select distinct department_id from employees

where department_id is not null and department_id not in(100);