摘要：
MYSQL: select emp_no,count(*) from salaries group by emp_no having count(*) > 15; 阅读全文
posted @ 2021-10-12 08:23
Sempron2800+
阅读(31)
评论(0)
推荐(0)
摘要：
MYSQL: select last_name,first_name,dept_no from employees left join dept_emp on employees.emp_no=dept_emp.emp_no; 阅读全文
posted @ 2021-10-12 08:18
Sempron2800+
阅读(58)
评论(0)
推荐(0)
摘要：
MYSQL: select last_name,first_name,dept_no from employees join dept_emp on employees.emp_no=dept_emp.emp_no; 阅读全文
posted @ 2021-10-12 08:16
Sempron2800+
阅读(64)
评论(0)
推荐(0)
摘要：
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; 阅读全文
posted @ 2021-10-12 08:11
Sempron2800+
阅读(33)
评论(0)
推荐(0)
摘要：
MYSQL: select * from employees order by hire_date desc LIMIT 2,1; 阅读全文
posted @ 2021-10-12 08:06
Sempron2800+
阅读(55)
评论(0)
推荐(0)
摘要：
MYSQL： select * from employees order by hire_date desc LIMIT 0,1; 阅读全文
posted @ 2021-10-12 08:03
Sempron2800+
阅读(80)
评论(0)
推荐(0)
浙公网安备 33010602011771号