牛客973517831号
牛客973517831号
全部文章
题解
归档
标签
去牛客网
登录
/
注册
牛客973517831号
全部文章
/ 题解
(共7篇)
题解 | #创建一个actor表,包含如下列信息#
select user.name as u_n,client.name as c_n,max(login.date) as date from login inner join user on login.user_id = user.id inner join client on login.cl...
2021-07-14
0
283
题解 | #汇总各个部门当前员工的title类型的分配数目#
select d.* ,t.title ,count(title) as count from departments as d inner join dept_emp on d.dept_no = dept_emp.dept_no inner join titles as t on t.emp_...
2021-07-13
0
273
题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#
select t1.emp_no,de.emp_no,t1.emp_salary,salaries.salary as manager_salary from dept_manager as de inner join salaries on de.emp_no = salaries.emp_no...
2021-07-13
0
314
题解 | #获取所有非manager员工当前的薪水情况#
select d.dept_no,e.emp_no,s.salary from employees as e inner join salaries as s on e.emp_no = s.emp_no inner join dept_emp as d on d.emp_no = e.emp_...
2021-07-13
0
301
题解 | #查找在职员工自入职以来的薪水涨幅情况#
select e.emp_no,(s2-s1) as growth from employees as e inner join (select e.emp_no,s.salary as s2 from employees as e inner join salaries as s on e.em...
2021-07-13
0
282
题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#
select employees.emp_no,max(salaries.salary),employees.last_name,employees.first_name from employees inner join salaries on employees.emp_no = sala...
2021-07-12
1
285
题解 | #获取每个部门中当前员工薪水最高的相关信息#
select t1.dept_no,t1.emp_no,max(salary) from (select dept_emp.dept_no,dept_emp.emp_no,salaries.salary from dept_emp inner join salaries on dept_emp.e...
2021-07-12
1
290