想潜水的迪恩想要offer

分类

/ 注册

全部文章（共40篇）

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

select ds.dept_no, dep.dept_name, count(dep.dept_name) as sum from departments dep right join (select de.emp_no, de....

2024-09-15

0 106

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

#第一版，这是取出经理的薪水 # (select # mg_salary.dept_no, # mg_salary.emp_no, # mg_salary.salary # from # (select # manager_no.dept...

2024-09-15

1 114

dense_rank()里面双排序

#第一版 select emp_no, salary, dense_rank() over(order by salary desc) as t_rank from salaries # select # emp_no, # ...

2024-09-15

1 109

上一题目215题，最终形式

select owcs.emp_no,owcs.growth from (select muqian.emp_no,(muqian.salary - douyou.salary) as growth from (select s.emp_no,s.salary from salar...

2024-09-14

1 82

连接后到底要不要加别名？

select muqian.emp_no,(muqian.salary -douyou.salary) as growth from (select s.emp_no,s.salary from salaries s where s.to_date = '9999-01-...

2024-09-14

1 98

一列对多列

select juhe.id, juhe.job, juhe.score from (select *, avg(score) over(partition by job) avg_s from grade...

2024-09-13

1 93

窗口函数求平均分精确到3位数

select avg_s.jobs, round(avg_s.avg,3) from (select distinct(job) jobs, avg(score) over(partition by job) avg ...

2024-09-13

1 95

刷题通过的题目排名，连立两个order by

select id, number, dense_rank() over(order by number desc) as t_rank from passing_number order by t_rank,id 下面是逐行解释：select *: 这部分指定...

2024-09-13

0 95

如何找到出现三次以上相同积分的数据

select number from grade group by number having count(number) >= 3 order by number 题目要求先对number进行分区，然后统计出每一个分区内部的相同的number数量，实际上就是先聚会再求值。忘记了使用ha...

2024-09-13

0 85

如何求统计salary的累计和running_total

select emp_no, salary, sum(salary) over(order by emp_no) as running_total from salaries where to_date = "9999-01-01"; sum(...

2024-09-12

0 110