张多盐
张多盐
全部文章
题解
归档
标签
去牛客网
登录
/
注册
张多盐的博客
全部文章
/ 题解
(共47篇)
题解 | #使用子查询的方式找出属于Action分类的所有电影对应的title,description#
select a.title,a.description from (select f.film_id,fc.category_id,title,description from film f join film_category fc on f.film_id = fc.film_id)a ...
Mysql
2021-10-27
0
247
题解 | #汇总各个部门当前员工的title类型的分配数目#
# 部门员工表 select a.dept_no as dept_no ,a.dept_name as dept_name ,b.title as title ,count(b.title) as count_n from (select de.dept_no,de.dept_name,dem.e...
Mysql
2021-10-27
0
232
题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#
# 部门经理的工资表 # with m_s,em_s as # (select *from dept_manager d # inner join salaries s # on d.emp_no = s.emp_no) m_s # # 员工的薪水(包括经理的)总表 # (select*from ...
Mysql
2021-10-27
0
160
题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#
# 部门经理的工资表 # with m_s,em_s as # (select *from dept_manager d # inner join salaries s # on d.emp_no = s.emp_no) m_s # # 员工的薪水(包括经理的)总表 # (select*from ...
Mysql
2021-10-27
0
231
题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#
# 部门经理的工资表 # with m_s,em_s as # (select *from dept_manager d # inner join salaries s # on d.emp_no = s.emp_no) m_s # # 员工的薪水(包括经理的)总表 # (select*from ...
Mysql
2021-10-27
0
230
题解 | #统计各个部门的工资记录数#
# 部门的工资记录数 select d.dept_no,dept_name,sum(a.sum_n) from dept_emp d left join departments dp on d.dept_no = dp.dept_no left join (select emp_no,cou...
Mysql
2021-10-25
0
165
题解 | #查找在职员工自入职以来的薪水涨幅情况#
# # 入职的薪水表 with a as (SELECT e.emp_no,s.salary as first_salary from employees e left join salaries s on e.emp_no = s.emp_no where e.hire_date = s.fro...
Mysql
2021-10-13
0
317
首页
上一页
1
2
3
4
5
下一页
末页