不想上网课的高级磨洋工练习时长两年半

分类

/ 注册

全部文章（共69篇）

题解 | 统计各个部门的工资记录数

select C.dept_no, C.dept_name, count(D.salary) as sum from ( select A.dept_no, A.dept_name, ...

2025-10-02

0 22

题解 | 查找所有员工的last_name和first_name以及对应的dept_name

select C.last_name,C.first_name, D.dept_name from ( select A.last_name,A.first_name,B.dept_no from employees A left join dept_emp B ...

2025-10-02

0 23

题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary

select emp_no, salary, last_name, first_name from ( select A.emp_no, B.salary, A.last_...

2025-10-02

0 25

题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary

select emp_no,salary from (select emp_no, salary, dense_rank() over (order by salary DESC) as rk from salaries) as A where rk = 2 order by emp_no ASC

2025-10-02

0 18

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

select A.title, avg(B.salary) from titles A left join salaries B on A.emp_no = B.emp_no group by A.title order by avg(B.salary) ASC

2025-10-02

0 25

题解 | 查找employees表emp_no与last_name的员工信息

select emp_no, birth_date, first_name, last_name, gender, hire_date from employees where emp_no % 2 = 1 and last_name != 'Mary' order by hire_date DE...

2025-10-02

0 16

题解 | 获取每个部门中薪水最高的员工相关信息

select dept_no, emp_no, salary from (select A.dept_no, A.emp_no, B.salary, (row_number() over (partition by A.dept_no order by B.sal...

2025-10-02

0 18

题解 | 获取所有员工当前的manager

select A.emp_no,B.emp_no as manager from dept_emp A INNER join dept_manager B on A.dept_no = B.dept_no where A.emp_no != B.emp_no;

2025-10-02

0 21

题解 | 获取所有非manager的员工emp_no

select emp_no from employees where emp_no NOT in (select emp_no from dept_manager )

2025-10-02

0 19

题解 | 找出所有员工当前薪水salary情况

select distinct salary from salaries order by salary DESC

2025-10-02

0 22