题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#
查找描述信息中包含robot的电影对应的分类名称以及电影数目，而且还需要该分类对应电影数量>=5部
http://www.nowcoder.com/practice/3a303a39cc40489b99a7e1867e6507c5
select * from (
select CASE WHEN salaries.salary > (select salary from salaries where salaries.emp_no = dept_manager.emp_no )
THEN dept_emp.emp_no END,
CASE WHEN salaries.salary > (select salary from salaries where salaries.emp_no = dept_manager.emp_no )
THEN dept_manager.emp_no END,
CASE WHEN salaries.salary > (select salary from salaries where salaries.emp_no = dept_manager.emp_no )
THEN salaries.salary END,
CASE WHEN salaries.salary > (select salary from salaries where salaries.emp_no = dept_manager.emp_no )
THEN (select salary from salaries where salaries.emp_no = dept_manager.emp_no) END a
from dept_emp join salaries join dept_manager on
dept_emp.emp_no = salaries.emp_no and dept_emp.dept_no = dept_manager.dept_no
where dept_emp.emp_no not in (select emp_no from dept_manager)
) where a <>'None'
查看20道真题和解析
