GB279824

分类

/ 注册

全部文章（共162篇）

题解 | 针对actor表创建视图actor_name_view

create view actor_name_view as select first_name as first_name_v, last_name as last_name_v from actor;

2025-05-23

0 21

题解 | 对first_name创建唯一索引uniq_idx_firstname

create unique index uniq_idx_firstname on actor(first_name); create index idx_lastname on actor(last_name); create unique index 创建唯一索引create index 创建普...

2025-05-23

0 19

题解 | 使用子查询的方式找出属于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 23

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

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

2025-05-23

1 23

题解 | 获取所有非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 19

题解 | 对所有员工的薪水按照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 21

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

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 22

题解 | 查找所有员工的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 22

题解 | 获取当前薪水第二多的员工的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 25

题解 | 统计出当前各个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 25