王钲超

分类

题解(14)

/ 注册

全部文章（共14篇）

统计出当前各个title类型对应的员工当前薪水对应的平均工资

select titles.title, avg(salaries.salary) as avgfrom salaries, titleswhere titles.to_date='9999-01-01' and salaries.to_date='9999-01-01'and salaries....

2020-08-12

0 649

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

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 1596

查找所有已经分配部门的员工的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 681

查找当前薪水详情以及部门编号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 673