存几分期许

分类

/ 注册

全部文章（共167篇）

题解 | 使用子查询的方式找出属于Action分类的所有电影对应的title,description

select title, description from film_category a join category b on a.category_id=b.category_id join film c on a.film_id=c.film_id where name='Action'

2025-08-15

0 29

题解 | 使用join查询方式找出没有分类的电影id以及名称

select a.film_id, title from film a left join film_category b on a.film_id=b.film_id where b.film_id is null

2025-08-15

0 27

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

select temp.dept_no, dept_name, title, count(1) as count from ( select dept_no, title from dept_emp a join titles b on a.emp_no=b.emp_no ) tem...

2025-08-15

0 29

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

with t as ( select a.emp_no, b.emp_no as manager_no, c.salary as emp_salary, c2.salary as manager_salary from dept_emp a join dept_manager...

2025-08-15

0 28

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

with t as ( select emp_no from employees where emp_no not in ( select emp_no from dept_manager ) ) select a.dept_no, t.emp_no,...

2025-08-15

0 40

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

select emp_no, salary, rn as t_rank from ( select emp_no, salary, dense_rank() over(order by salary desc) as rn from salaries ) temp order by ...

2025-08-15

0 37

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

select c.dept_no, dept_name, sum from ( select dept_no, count(1) as sum from dept_emp a join salaries b on a.emp_no=b.emp_no group by dept...

2025-08-15

0 36

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

with t_hire as ( select a.emp_no, salary from employees a join salaries b on a.emp_no=b.emp_no where from_date=hire_date ), t_current as (...

2025-08-15

0 26

题解 | 获取有奖金的员工相关信息。

select a.emp_no, first_name, last_name, btype, salary, round( case when btype=1 then salary*0.1 when btype=2 then salary*0.2 else salary*0...

2025-08-15

0 26

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

select last_name, first_name, dept_name from employees a left join dept_emp b on a.emp_no=b.emp_no left join departments c on b.dept_no=c.dept_no

2025-08-14

0 24