牛客901112099号

分类

/ 注册

全部文章（共21篇）

题解 | #获取有奖金的员工相关信息。#

select t1.emp_no en, first_name, last_name, btype, salary, case when btype = 1 then salary * 0.1 when btype = ...

2024-09-08

0 114

题解 | #获取员工当前的薪水比其manager当前薪水还高

#将员工信息和工资表连接起来 # select t1.emp_no e1,t1.dept_no d1,t2.dept_no d2,t2.emp_no e2,salary s # from dept_emp t1 left join dept_manager t2 on (t1.dept_no=t2....

2024-09-03

0 88

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

# #最开始工资 # select employees.emp_no e1,salary s1,from_date f1,to_date t2 # from employees left join salaries on (employees.emp_no=salaries.emp_no) # wh...

2024-09-02

1 84

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

#先寻找最高工资 select max(salary) from salaries #再寻找第二高工资 # select max(salary) # from salaries # where salary != (select max(salary) # from salaries) #找到工资...

2024-09-01

0 77

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

select emp_no,salary from salaries where salary = (select salary from salaries group by salary order by salary desc limit 1 offset 1)

2024-09-01

0 75

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

# 方法1 select dept_no,emp_no,salary from (select *,dense_rank()over(partition by dept_no order by salary desc) rank1 from (select dept_no,dept_emp.emp_...

2024-09-01

0 75

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

select dept_no,emp_no,salary from (select *,dense_rank()over(partition by dept_no order by salary desc) rank1 from (select dept_no,dept_emp.emp_no,sal...

2024-09-01

0 74

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

select employees.emp_no from employees left join dept_manager on (employees.emp_no = dept_manager.emp_no) where dept_no is null

2024-08-31

1 73

题解 | #查找薪水记录超过15条的员工号以及记录次数#

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

2024-08-31

0 64

题解 | #查找员工的名和姓及对应部门编号dept_no#

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

2024-08-31

0 81