在走神的马来熊

分类

/ 注册

全部文章（共37篇）

题解 | #查找在职员工自入职以来的薪水涨幅情况#

改了好多次，感觉最简洁的一版 select s1.emp_no,s2.salary-s1.salary growth from (select emp_no,salary from salaries where (emp_no,to_date) in(select emp_no,min(to_d...

2024-04-14

0 141

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

select dept_no, sa.emp_no, salary from dept_emp de join salaries sa on de.emp_no = sa.emp_no where sa.to_date = '9999-01-01' and (dept_no,salary) in(...

2024-04-11

1 152

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

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

2024-04-09

0 118

题解 | #查找工号奇数的员工信息#

select * from employees where mod(emp_no,2) != 0 and last_name <> 'Mary' order by hire_date desc

2024-04-07

0 176

题解 | #薪水记录超过15条的员工号以及其对应的次数t#

select emp_no, count(salary) t from salaries group by emp_no having count(salary) > 15

2024-04-06

1 158

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

select * from employees where hire_date = (select distinct hire_date from employees order by hire_date desc limit 2,1) 一种思路，供参考。主要在于对入职日期进行去重

2024-04-06

1 153

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

select * from employees order by hire_date desc limit 1

2024-04-06

1 177