首页 > 代码库 > distinct

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

技术分享

 

distinct