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);

 

posted on 2016-09-12 17:02  沫小辉  阅读(215)  评论(0编辑  收藏  举报