rubyrubylulu
rubyrubylulu
全部文章
分类
题解(6)
归档
标签
去牛客网
登录
/
注册
rubyrubylulu的博客
全部文章
(共5篇)
题解 | #使用子查询的方式找出属于Action分类的所有电影对应的title,description#
select film.title,film.description from film left join film_category on film.film_id=film_category.film_id left join category on category.catego...
Mysql
2022-04-26
0
158
题解 | #汇总各个部门当前员工的title类型的分配数目#
select distinct departments.*,titles.title,count(titles.title) over (partition by departments.dept_no , titles.title) from departments left join dept_...
Mysql
2022-04-26
0
191
题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#
select emp_sal.*, salaries.salary as manager_salary from (select dept_emp.emp_no, dept_manager.emp_no as manager_no,salaries.salary as emp_salary from...
Mysql
2022-04-26
0
176
题解 | #获取所有非manager员工当前的薪水情况#
select dept_emp.dept_no,dept_emp.emp_no,salaries.salary from dept_emp left join salaries on salaries.emp_no=dept_emp.emp_no where dept_emp...
Mysql
2022-04-25
0
147
题解 | #查找最晚入职员工的所有信息#
select departments.*,count(salaries.salary)as sum from departments right join dept_emp on departments.dept_no=dept_emp.dept_no left join salarie...
Sqlite
Mysql
2022-04-25
1
180