GB279824

分类

/ 注册

全部文章（共190篇）

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

select title,description from film f where film_id in ( select film_id from film_category where category_id in ( select category_i...

2025-05-23

0 39

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

select film_id, title from film where film_id not in ( select film_id from film_category )

2025-05-23

1 42

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

select d.dept_no,e.emp_no,salary from employees e left join dept_emp d on e.emp_no = d.emp_no left join salaries s on s.emp_no = d.emp_no where d....

2025-05-23

1 33

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

select emp_no,salary, DENSE_RANK() OVER (order by salary DESC) as dr from salaries order by salary DESC, emp_no ASC;

2025-05-23

1 34

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

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

2025-05-23

1 38

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

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

2025-05-23

1 37

题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary

select c.emp_no,c.salary from ( select emp_no,salary, DENSE_RANK() OVER (order by salary DESC) as dr from salaries ) as c where c.dr = 2; ...

2025-05-23

1 47

题解 | 统计出当前各个title类型对应的员工当前薪水对应的平均工资

select title, avg(s.salary) from titles t left join salaries s on t.emp_no = s.emp_no group by title order by avg(s.salary) ASC;

2025-05-23

1 45

题解 | 查找employees表emp_no与last_name的员工信息

select * from employees where emp_no % 2 <> 0 and last_name <> 'Mary' order by hire_date DESC;

2025-05-23

0 50

题解 | 获取每个部门中薪水最高的员工相关信息

select dept_no, s.emp_no, salary from dept_emp e left join salaries s on e.emp_no=s.emp_no where (dept_no,salary) in ( select dept_no,max...

2025-05-23

0 46