自然数

分类

题解(5)

/ 注册

全部文章（共5篇）

题解 | #获得积分最多的人(三)#

select t.id, t.name, t.grade_sumfrom(select u.id,u.name,sum(g.grade_num * case when type = 'add' then 1 else -1 end) as grade_sum,dense_rank() over(or...

2021-07-25

1 544

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

select t.id, t.name, t.grade_sum from (select u.id,u.name, sum(g.grade_num * case when type = 'add' then 1 else -1 end) as grade_sum, dense_rank() ove...

2021-07-25

1 497

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

select t1.emp_no, t2.emp_no as manager_no, t1.salary as emp_salary, t2.salary as manager_salary from (select d.emp_no,d.dept_no,s.salary from dept_emp...

2021-07-17

7 650

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

select emp_no, salary, DENSE_RANK() over (order by salary desc) as t_rank from salaries order by t_rank asc, emp_no asc使用窗函数 dense_rank()

2021-07-15

1 478

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

select t.dept_no, t.dept_name, count(1) as cnt from (select s.emp_no,s.salary,d.dept_no,dd.dept_name from salaries s left join dept_emp d on s.emp_no...

2021-07-15

1 440