牛客264897283号

分类

/ 注册

全部文章（共51篇）

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

select emp_no, salary, dense_rank() over ( order by salary desc ) as t_rank from ( select emp_...

2025-03-12

0 54

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

select b.dept_no, a.dept_name, count(c.salary) as sum from salaries c left join dept_emp b using (emp_no) left join department...

2025-03-12

0 83

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

with c as ( select a.emp_no, b.salary from employees a join salaries b on a.emp_no...

2025-03-12

0 73

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

with c as ( select a.emp_no, b.salary from employees a join salaries b on a.emp_no...

2025-03-12

0 76

题解 | 查找所有员工的last_name和first_name以及对应的dept_name

select a.last_name, a.first_name, b.dept_name from employees a left join dept_emp c using (emp_no) left join departments b using...

2025-03-12

0 62

题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary

select a.emp_no, b.salary, a.last_name, a.first_name from employees a join salaries b using (emp_no) where b.salary = ( ...

2025-03-12

0 53

题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary

select emp_no, salary from ( select emp_no, salary, rank() over ( order by ...

2025-03-12

0 55

题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary

select emp_no, salary from ( select emp_no, salary, rank() over ( order by ...

2025-03-12

0 43

题解 | 统计出当前各个title类型对应的员工当前薪水对应的平均工资

select a.title,avg(b.salary) from titles a join salaries b using(emp_no) group by a.title order by avg(b.salary) asc

2025-03-12

0 65

题解 | 查找employees表emp_no与last_name的员工信息

select emp_no, birth_date, first_name, last_name, gender, hire_date from employees where mod(emp_no, 2) = 1 and la...

2025-03-12

0 49