sky丶Mamba2

分类

c++(1) c语言(2) Java后端(1) mysql(2) PAT(1) PAT (Basic Level)(76) 其它(5) 大学文档(7) 数据分析(6) 社区发现(1) 算法(1) 题解(80)

/ 注册

TA的专栏 80篇文章 0人订阅

80篇文章 1717人学习

全部文章（共183篇）

题解 | 26#汇总各个部门当前员工的title类型的分配数目# 来自专栏

select de.dept_no ,dm.dept_name ,title,count(*) as count from dept_emp de join departments dm on de.dept_no=dm.dept_no join titles t on de.emp_no=t....

2021-08-17

0 332

题解 | 79#牛客的课程订单分析(三)# 来自专栏

select * from order_info where user_id in ( select user_id from order_info a where date>'2025-10-15' and product_name in ('C++',...

2021-08-17

0 363

题解 | 69#牛客每个人最近的登录日期(四)# 来自专栏

select date ,sum(case when (user_id,date) in ( select user_id,min(date) from login group by user_id ) then 1 else 0 end) from login g...

2021-08-17

0 359

题解 | 18#获取当前薪水第二多的员工的emp_no以及其对应的薪水salary# 来自专栏

select e.emp_no ,salary ,last_name ,first_name from employees e join salaries s on e.emp_no=s.emp_no where salary = ( select max(salary) fr...

2021-08-16

0 353

题解 | 54#查找排除当前最大、最小salary之后的员工的平均工资avg_salary# 来自专栏

select avg(salary) avg_salary from salaries where salary != (select max(salary) from salaries where to_date='9999-01-01') and salary != (select min(s...

2021-08-16

0 396

题解 | 71#牛客每个人最近的登录日期(六)# 来自专栏

select u.name u_n,p.date,sum(number) over(partition by name order by date) ps_num from user u join passing_number p on u.id=p.user_id order by date,u_...

2021-08-16

0 313

题解 | 89#获得积分最多的人(一)# 来自专栏

select name,sum(grade_num) grade_sum from user u join grade_info g on u.id=g.user_id group by name order by grade_sum desc limit 1思路：用一个排序和limit就好了，不...

2021-08-16

0 265

题解 | 25#获取员工其当前的薪水比其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 join dept_manager dm on de.dept...

2021-08-16

0 411

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

select emp_no,salary,dense_rank() over (order by salary desc) from salaries order by salary desc,emp_no思路：利用窗口函数的 dense_rank() ，后面对salary和emp_no 进行排序

2021-08-15

0 347

题解 | 59#获取有奖金的员工相关信息。# 来自专栏

select e.emp_no,e.first_name,e.last_name,eb.btype,s.salary, case when eb.btype=1 then s.salary*0.1 when eb.btype=2 then s.salary*0.2 else s....

2021-08-15

0 337