--重复行
select department_id from employees;
select distinct department_id from employees;
select distinct department_id,job_id from employees;
只有当110 AC_ACCOUNT 和 110 AC_MGR 相同时,才可以合并消除重复(要么左边改变成右边,要么右边变成左边)
--重复行
select department_id from employees;
select distinct department_id from employees;
select distinct department_id,job_id from employees;
只有当110 AC_ACCOUNT 和 110 AC_MGR 相同时,才可以合并消除重复(要么左边改变成右边,要么右边变成左边)