YishanZ

题解

/ 注册

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

题解 | #查找所有员工的last_name和first_name以及对应部门编号dept_no#

SELECT e.last_name, e.first_name, d.dept_no FROM employees AS e LEFT JOIN dept_emp AS d ON e.emp_no = d.emp_no

Mysql

2022-01-08

1 234

题解 | #查找所有已经分配部门的员工的last_name和first_name以及dept_no#

SELECT e.last_name, e.first_name, d.dept_no FROM employees AS e, dept_emp AS d WHERE e.emp_no = d.emp_no AND d.dept_no IS NOT NULL;

Mysql

2022-01-08

1 298

题解 | #查找当前薪水详情以及部门编号dept_no#

SELECT s.emp_no, s.salary, s.from_date, s.to_date, d.dept_no FROM salaries AS s, dept_manager AS d WHERE s.emp_no = d.emp_no

Mysql

2022-01-08

1 245

题解 | #查找入职员工时间排名倒数第三的员工所有信息#

SELECT * FROM employees WHERE hire_date = ( SELECT DISTINCT hire_date FROM employees ORDER BY hire_date DESC LIMIT 2, 1);

Mysql

2022-01-08

1 274