![](https://img-blog.csdnimg.cn/c45bbecf50824e3bb8b09839e51874b5.jpg?x-oss-process=image/resize,m_fixed,h_224,w_224)
数据库SQL-81题
牛客上的81道SQL题目
ClimberCoding
基础不牢,地动山摇…
展开
-
SQL3 查找当前薪水详情以及部门编号dept_no
SQL3 查找当前薪水详情以及部门编号dept_no题目题解select s.*, d.dept_nofrom salaries as sjoin dept_manager as don s.emp_no = d.emp_noorder by s.emp_no;原创 2021-11-23 23:48:32 · 370 阅读 · 0 评论 -
SQL2 查找入职员工时间排名倒数第三的员工
SQL2 查找入职员工时间排名倒数第三的员工题目题解1select * from employeesorder by hire_date desclimit 2, 1;题解2select * from employeeswhere hire_date = ( select distinct hire_date from employees order by hire_date desc limit 2, 1);...原创 2021-11-23 23:47:53 · 417 阅读 · 0 评论 -
SQL1 查找最晚入职员工的所有信息
SQL1 查找最晚入职员工的所有信息题目题解1select * from employeesorder by hire_date desclimit 1;题解2select * from employeeswhere hire_date = (select max(hire_date) from employees);原创 2021-11-23 23:46:45 · 195 阅读 · 0 评论