【SQL】1789. 员工的直属部门

最新推荐文章于 2024-09-27 11:31:35 发布

zzamx

最新推荐文章于 2024-09-27 11:31:35 发布

阅读量193

点赞数 8

本文链接：https://blog.csdn.net/xiaoyue_/article/details/137132589

版权

Leetcode 同时被 2 个专栏收录

119 篇文章 2 订阅

订阅专栏

SQL

64 篇文章 1 订阅

订阅专栏

题目描述

leetcode题目：1789. 员工的直属部门

在这里插入图片描述

Code

写法一：并集

select employee_id, department_id
from Employee 
where primary_flag = 'Y'
union
select employee_id, department_id
from Employee
group by employee_id
having count(*) = 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(*) = 1
)