1. 查找最晚员工信息
SELECT * FROM employees WHERE hire_date=(SELECT MAX(hire_date) FROM employees) LIMIT 0,1
SELECT * FROM employees ORDER BY hire_date DESC LIMIT 0,1
注意:一定要增加limit,因为最晚入职的人可能不止一个
2. 查找最晚入职排名第三的员工信息
SELECT * FROM employees ORDER BY hire_date DESC LIMIT 2,1
3. 查找当前薪水详情及部门编号
SELECT salaries.emp_no, salaries.salary, salaries.from_date, salaries.to_date, dept_manager.dept_no
FROM salaries
LEFT JOIN dept_manager
ON dept_manager.emp_no = salaries.emp_no
WHERE dept_manager.to_date='9999-01-01' AND salaries.to_date='9999-01-01'
4. 查找所有已分配部门员工的first_name和last_name
SELECT a.last_name, a.first_name, b.dept_no
FROM employees AS a, dept_emp AS b
WHERE a.emp_no = b.emp_no