牛客112419884号
牛客112419884号
全部文章
分类
题解(15)
归档
标签
去牛客网
登录
/
注册
牛客112419884号的博客
全部文章
(共11篇)
题解 | #使用join查询方式找出没有分类的电影id以及名称#
select a.film_id,a.titlefrom film aleft join film_category b on a.film_id=b.film_idleft join category c on b.category_id=c.category_idwhere c.category...
2021-08-13
0
241
题解 | #汇总各个部门当前员工的title类型的分配数目#
select a.dept_no,b.dept_name,c.title,count(c.title)from dept_emp ainner join departments b on a.dept_no=b.dept_noinner join titles c on c.emp_no=a.emp...
2021-08-13
0
212
题解 | #获取所有非manager员工当前的薪水情况#
select a.emp_no,e.emp_no manager_no,b.salary emp_salary,e.salary manager_salary from dept_emp a inner join salaries b on a.emp_no=b.emp_no inner join ...
2021-08-13
0
237
题解 | #获取所有非manager员工当前的薪水情况#
select c.dept_no,a.emp_no,d.salaryfrom employees ainner join dept_emp c on a.emp_no=c.emp_noinner join salaries d on c.emp_no=d.emp_nowhere a.emp_no...
2021-08-13
0
184
题解 | #统计各个部门的工资记录数#
select a.emp_no,a.salary,( select count(distinct c.salary) from salaries c where c.salary>=a.salary ) t_rank from salaries a order by a.salary desc...
2021-08-13
0
365
题解 | #统计各个部门的工资记录数#
select a.dept_no,a.dept_name,(count(c.emp_no)) sum from departments a inner join dept_emp b on a.dept_no=b.dept_no inner join salaries c on c.emp_no=b...
2021-08-13
0
215
题解 | #查找在职员工自入职以来的薪水涨幅情况#
select b.emp_no,(b.salary-c.salary)growthfrom employees ainner join salaries b on b.emp_no=a.emp_no and b.to_date='9999-01-01'inner join salaries c on...
2021-08-13
0
249
题解 | #查找所有员工的last_name和first_name以及对应的dept_name#
select a.last_name,a.first_name,c.dept_namefrom employees aleft join dept_emp b on b.emp_no=a.emp_noleft join departments c on b.dept_no=c.dept_no
2021-08-12
0
298
题解 | #获取每个部门中当前员工薪水最高的相关信息#
select e.emp_no,s.salary,e.last_name,e.first_name from employees e join salaries s on e.emp_no=s.emp_no and s.salary = ( &nbs...
2021-08-12
1
234
题解 | #获取每个部门中当前员工薪水最高的相关信息#
select * from ( select aa.title,(select avg(b.salary) from titles a inner join salaries b on a.emp_no=b.emp_no ...
2021-08-12
0
236
首页
上一页
1
2
下一页
末页