自己整理的sql笔试题

select * from employees

where hire_date =

(select max(hire_date) from employees)

select * from employees where hire_date=(select distinct hire_date from

employees order by hire_date desc limit 2,1);

where dept_manager.to_date = '9999-01-01'

and salaries.to_date = '9999-01-01';

select employees.last_name, first_name, dept_emp.dept_no

from dept_emp inner join employees where

dept_emp.emp_no = employees.emp_no;