牛客939883218号

分类

题解(6)

/ 注册

全部文章（共5篇）

题解 | #考试分数(五)#

with t As ( select *,row_number() over(partition by job order by score desc) r_rank from grade) select t.id,t.job,t.score,t.r_rank from t left join (...

Mysql

2021-09-27

0 267

题解 | #牛客每个人最近的登录日期(四)#

select l1.date,count(distinct case when l2.user_id IS null then l1.user_id else null end) from login l1 left join login l2 on l1.user_id=l2.user_id an...

Mysql

2021-09-17

0 248

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

SELECT de.emp_no, dm.emp_no AS manager_no, s1.salary AS emp_salary, s2.salary AS manager_salary FROM dept_emp de LEFT JOIN de...

2021-08-16

0 262

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

薪水涨幅：当前薪资-入职薪资在职员工：to_date='9999-01-01' 求入职薪资： SELECT e.emp_no,s.salary FROM employees e LEFT JOIN salaries s ON e.emp_no=s.emp_no AND e.hire_date=...

2021-08-16

0 227

获取当前（to_date='9999-01-01'）薪水第二多的员工的emp_no以及其对应的薪水salary

select emp_no , salary from salaries where salary=(select salary from salaries where to_date='9999-01-01' ...

2020-05-11

2 858