张多盐

题解

/ 注册

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

题解 | #获取员工其当前的薪水比其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 214

题解 | #获取员工其当前的薪水比其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 281

题解 | #获取员工其当前的薪水比其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 288

题解 | #统计各个部门的工资记录数#

# 部门的工资记录数 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 220

题解 | #查找在职员工自入职以来的薪水涨幅情况#

# # 入职的薪水表 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 374