王钲超

题解

/ 注册

全部文章 / 题解（共13篇）

获取所有部门中当前员工薪水最高的相关信息

select dept_no, emp_no, max(salary) as salary from(select d.dept_no as dept_no, d.emp_no as emp_no, s.salary as salaryfrom dept_emp d left join salari...

2020-08-11

12 1593

查找所有已经分配部门的员工的last_name和first_name以及dept_no

/* 方法一笛卡尔积select t2.last_name, t2.first_name, t1.dept_nofrom dept_emp as t1, employees as t2where t1.emp_no = t2.emp_no*/ -- 方法二 left joinselect t2.l...

2020-08-11

3 679

查找当前薪水详情以及部门编号dept_no

/* select t1.emp_no, t2.salary,t2.from_date,t2.to_date,t1.dept_nofrom salaries as t2 left join dept_manager as t1 on t1.emp_no = t2.emp_nowhere t2.to_...

2020-08-11

3 668