题解 | #获取有奖金的员工相关信息。#
获取有奖金的员工相关信息。
http://www.nowcoder.com/practice/5cdbf1dcbe8d4c689020b6b2743820bf
SELECT e.emp_no
,e.first_name
,e.last_name
,eb.btype
,s.salary
,s.salary*eb.btype * 0.1
FROM employees e left join (select emp_no,salary from salaries where to_date='9999-01-01') s
on e.emp_no=s.emp_no
left join emp_bonus eb on e.emp_no = eb.emp_no
WHERE eb.emp_no is not null
接
查看14道真题和解析
