牛客788149274号

分类

题解(3)

/ 注册

全部文章（共3篇）

题解 | #获取所有非manager员工当前的薪水情况#

select c.dept_no,c.emp_no,d.salary FROM (select a.emp_no,b.dept_no from employees a left join dept_emp b on a.emp_no=b.emp_no) c left join salaries d ...

Mysql

2022-02-13

1 227

题解 | #对所有员工的薪水按照salary降序进行1-N的排名#

SELECT emp_no,salary,t_rank from (select emp_no,salary,DENSE_RANK() over( order by salary desc) as t_rank from salaries order by emp_no) as d order by...

Mysql

2022-02-13

1 230

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

SELECT d.dept_no,c.dept_name,count(salary) from (select b.dept_no,a.salary,b.emp_no from salaries a left join dept_emp b on a.emp_no=b.emp_no) d left ...

Mysql

2022-02-13

1 285