Joneln

题解

专题(8)

/ 注册

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

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

select emp_no, salary from salaries where to_date = '9999-01-01'; select employees.emp_no, salary from salaries, employees where salaries.emp_no = em...

Mysql

2021-09-24

1 527

题解 | #查找所有员工的last_name和first_name以及对应的dept_name# 来自专栏

select employees.emp_no as emp_no, dept_no, last_name, first_name from employees left outer join dept_emp on employees.emp_no = dept_emp.emp_no; sele...

Mysql

2021-09-24

0 427

题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary# 来自专栏

select max(salary) from salaries; select max(salary) from salaries where salary <> (select max(salary) from salaries); select emp_no, salary f...

Mysql

2021-09-24

0 390

题解 | #获取每个部门中当前员工薪水最高的相关信息# 来自专栏

SELECT currentsalary.dept_no, currentsalary.emp_no, currentsalary.salary AS salary FROM -- 创建maxsalary表用于存放当前每个部门薪水的最大值 (SELECT d.dept_no, MAX(s....

Mysql

2021-09-23

1 343

题解 | #获取所有员工当前的manager# 来自专栏

select dept_emp.emp_no as emp_no, dept_manager.emp_no as manager from dept_emp left outer join dept_manager on dept_emp.dept_no = dept_manage...

Mysql

2021-09-22

1 381

题解 | #获取所有非manager的员工emp_no# 来自专栏

SELECT employees.emp_no as emp_no from employees left outer join dept_manager on employees.emp_no = dept_manager.emp_no where dept_manager.emp_no is N...

Mysql

2021-09-22

1 481

题解 | #查找薪水记录超过15次的员工号emp_no以及其对应的记录次数t# 来自专栏

SELECT emp_no, COUNT(salary) as t from salaries GROUP BY emp_no HAVING t > 15; where 在分组前过滤。 having 在分组后过滤。

Mysql

2021-09-22

1 371