摘要：
MYSQL: select emp_no,count(*) from salaries group by emp_no having count(*) > 15; 阅读全文
摘要：
MYSQL: select last_name,first_name,dept_no from employees left join dept_emp on employees.emp_no=dept_emp.emp_no; 阅读全文
摘要：
MYSQL: select last_name,first_name,dept_no from employees join dept_emp on employees.emp_no=dept_emp.emp_no; 阅读全文
摘要：
MYSQL: select salaries.*,dept_manager.dept_no from salaries join dept_manager on salaries.emp_no=dept_manager.emp_no order by salaries.emp_no; 阅读全文
摘要：
MYSQL: select * from employees order by hire_date desc LIMIT 2,1; 阅读全文
摘要：
MYSQL： select * from employees order by hire_date desc LIMIT 0,1; 阅读全文