会编程的发呆爱好者加麻加辣

分类

/ 注册

全部文章（共208篇）

题解 | 异常的邮件概率

select a.date, round(count(case when a.type='no_completed' then 1 else null end)/count(a.id),3) as p from( select e.id,e.send_id,e.receive_id,e.t...

2025-03-18

1 42

题解 | 给出employees表中排名为奇数行的first_name

select a.first_name from (select emp_no,first_name, row_number() over(order by first_name)as ranking from employees)a where a.ranking%2 !=0 order by a...

2025-03-18

0 33

题解 | 统计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(求和字段)over(partition by 字段...

2025-03-17

0 29

题解 | 汇总各个部门当前员工的title类型的分配数目

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

2025-03-16

0 42

题解 | 获取员工其当前的薪水比其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 d...

2025-03-16

0 33

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

select dept_no,emp_no,salary from ( select de.dept_no,e.emp_no,s.salary from employees e join dept_emp de on e.emp_no =de.emp_no join...

2025-03-16

0 43

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

select emp_no, salary,dense_rank() over(order by salary desc) as t_rank from salaries order by t_rank,emp_no 考察排序函数，注意dense_rank() over(order by sala...

2025-03-16

0 29

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

select d.dept_no,d.dept_name, count(s.salary) as sum from departments d join dept_emp de on d.dept_no = de.dept_no join salaries s on de.emp_no = s.e...

2025-03-16

0 25

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

select e.emp_no, (a.salary-b.salary)as growth from employees e join salaries a on e.emp_no=a.emp_no join salaries b on e.emp_no=b.emp_no where a.to...

2025-03-16

0 41

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

select e.last_name, e.first_name,d.dept_name from employees e left join dept_emp de on e.emp_no = de.emp_no left join departments d on de.dept_no = d...

2025-03-16

0 32