Master_zx

题解

/ 注册

全部文章 / 题解（共2篇）

题解 | #查找employees表emp_no与last_name的员工信息#

select * from employees where SUBSTRING(emp_no,5,1) in ('1','3','5','7','9') and last_name != 'Mary' order by hire_date DESC SUBSTRING 解题思路： 1.本题需要获取e...

Mysql Sqlite 数据库

2021-11-19

6 480

题解 | #获取每个部门中当前员工薪水最高的相关信息#

SELECT t.dept_no,t.emp_no,t.salary from (SELECT d.dept_no,s.emp_no,salary,rank()over(partition by dept_no order by salary desc) rk from salaries as s ...

Mysql Sqlite 数据库

2021-11-19

1 342