想潜水的迪恩想要offer

分类

/ 注册

全部文章（共40篇）

题解 | #批量插入数据#

INSERT INTO actor (actor_id,first_name,last_name,last_update) VALUES ('1','PENELOPE','GUINESS','2006-02-15 12:34:33'), ('2','NICK','WAHLBERG','2006-02...

2024-09-06

0 131

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

"select dd.dept_no,dd.dept_name,count(dd.dept_no) as sum from (salaries ss left join (select ds.dept_no,ds.dept_name,dp.emp_no from departments d...

2024-08-24

1 116

题解 | #获取当前薪水第二多的员工，无order by

select e.emp_no,s.salary,e.last_name,e.first_name from employees e join salaries s on e.emp_no = s.emp_no where s.salary = (select max(salary) from ...

2024-08-23

1 134

题解 | #获取当前薪水第二多的员工

select emp_no, salary from (select emp_no, salary, dense_rank() over (order by salary desc) as dense_salary from salaries) as ranked_salary where d...

2024-08-22

0 135

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

select huizong.dept_no, huizong.emp_no, huizong.maxSalary from (select de.dept_no, de.emp_no, Max(sa.salary) as maxSalary, rank() over (partition by ...

2024-08-17

1 118

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

select eemp_no, manager from (select de.emp_no as eemp_no, dm.emp_no as manager from dept_emp de left join dept_manager dm on de.dept_no = dm.dept_no...

2024-08-17

1 112

题解 |

select employees.last_name, employees.first_name, dept_emp.dept_no from employees left join dept_emp on employees.emp_no = dept_emp.emp_no left join...

2024-08-16

0 80

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

select salaries.emp_no, salaries.salary, salaries.from_date, salaries.to_date, dept_manager.dept_no from salaries join dept_manager on salaries....

2024-08-15

0 135

题解 | #查找入职员工时间排名倒数第三的员工所有信息#

select * from employees where hire_date =( select hire_date from employees group by hire_date order by hire_date desc limit 2,1 ); 难点...

2024-08-15

1 132

题解 | #查找最晚入职员工的所有信息#

select * from employees order by hire_date desc limit 1 用"*"，表示选取所有列，如何找到最晚入职的员工呢，直接用hire_date进行降序排序，然后用limit取出第一个即可。

2024-08-15

0 82