牛萍萍

题解

/ 注册

全部文章 / 题解（共15篇）

题解 | #SQL74 考试分数(三) #

select t.id, t.name, t.score from (select g.id, l.name, g.score, dense_rank() over(partition by language_id order by score desc) as rank_1 from grade ...

Mysql 题霸SQL篇

2021-09-17

1 457

题解 | #SQL33 创建一个actor_name表#

create table if not exists actor_name( first_name varchar(45) not null, last_name varchar(45) not null); insert into actor_name select first_...

Mysql

2021-09-15

1 443

题解 | #SQL29 用 join 方式找出没有分类的电影 id 及其名称#

select t.film_id, t.title from (select f.film_id, fy.category_id, f.title from film f left join film_category fy on f.film_id = fy.film_id) as t le...

Mysql

2021-09-15

0 372

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

select dp.dept_no, ds.dept_name, tt.title, count(dp.emp_no) from dept_emp dp left join titles tt on dp.emp_no = tt.emp_no left join departments ds on...

Mysql

2021-09-15

1 326

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

select t.emp_no, t.manager_no, t.emp_salary, t.manager_salary from (select dp.dept_no, dp.emp_no, dr.emp_no manager_no, ss.salary emp_salary, ss2...

Mysql

2021-09-15

3 441