VIy10

分类

/ 注册

全部文章（共10篇）

SQL223 4表相连+取非管理级人员

select d.dept_no, e.emp_no, s.salary from employees e join dept_emp d on e.emp_no = d.emp_no join dept_manager dm on dm.dept_n...

2026-01-18

0 33

SQL221 3表连接+分组行数统计

select d.dept_no,d.dept_name,count(s.salary) sum from departments d join dept_emp de on d.dept_no = de.dept_no join salaries s on de.emp_no = s.emp_no...

2026-01-18

0 37

SQL220 工资增幅，基于时间识别入职/当前工资

select a.emp_no,b.salary - a.salary growth from (select s.emp_no,s.salary from salaries s join employees e on e.hire_date = s.from_date) as a join (se...

2026-01-18

0 38

SQL218 3表连接

select last_name, first_name, dept_name from employees e left join dept_emp de on e.emp_no = de.emp_no left join departments d...

2026-01-18

0 36

SQL217：找NO2，selcet max() + where不等于

select rk.emp_no,rk.salary,e.last_name,e.first_name from employees as e right join (select emp_no, salary from salaries where salary =(select max(...

2026-01-18

0 31

SQL214：筛选id为奇数，where 字段 % 2 = 1

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 desc SQL...

2026-01-18

0 30

SQL211：分组里max值，排序窗口函数+where筛选

select dept_no,emp_no,salary from (select d.dept_no,d.emp_no,s.salary, dense_rank()over(partition by dept_no order by salary desc) as rk from dept_e...

2026-01-18

0 24

SQL210：where不能用select中定义的别名

select e.emp_no,m.emp_no as manager from dept_emp as e left join dept_manager as m on e.dept_no = m.dept_no where e.emp_no != m.emp_no 题目：SQL210 获取所有员...

2026-01-18

0 34

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

select sa.emp_no,sa.salary,sa.from_date,de.to_date,de.dept_no from salaries as sa right join dept_manager as de on sa.emp_no = de.emp_no order by sa....

2026-01-18

0 20

题解 | 查找入职员工时间升序排名的情况下的倒数第三的员工所有信息

select emp_no, birth_date, first_name, last_name, gender, hire_date from ( select emp_no, ...

2026-01-15

0 37