从现在开始准备每日刷题和记录进程,争取早日上岸。
select employee_id, department_id
from Employee
where primary_flag = 'Y' or employee_id in (
select employee_id
from Employee
group by employee_id
having count(employee_id) = 1
)
从现在开始准备每日刷题和记录进程,争取早日上岸。
select employee_id, department_id
from Employee
where primary_flag = 'Y' or employee_id in (
select employee_id
from Employee
group by employee_id
having count(employee_id) = 1
)