LeetCode刷题实战577：员工奖金
程序IT圈
共 330字，需浏览 1分钟
·
2022-04-11 11:52
解题
首先两表连接 这里需要左连接
select E.name, B.bonus
from Employee as E
left join Bonus as B
on E.empId = B.empId
select E.name, B.bonus
from Employee as E
left join Bonus as B
on E.empId = B.empId
where B.bonus <1000 or B.bonus is null;
评论