某公司人资系统有如下表及数据:
**员工表T_OMS_EMPLOYEE******
| **字段名称****** | **类型****** | **备注****** | **字段描述****** |
| ------------ | ------------ | ---------- | ------------ |
| EMPNO | NUMERIC(4) | NOT NULL | 工号 |
| ENAME | VARCHAR(10) | | 姓名 |
| JOB | VARCHAR(15) | | 职位 |
| MGR | NUMERIC(4) | | 直属领导工号 |
| HIREDATE | DATETIME | | 入职时间 |
| SAL | NUMERIC(7,2) | | 工资 |
| DEPTNO | NUMERIC(2) | | 部门编号 |
该表数据如下:
| **EMPNO****** | **ENAME****** | **JOB****** | **MGR****** | **HIREDATE****** | **SAL****** | **DEPTNO****** |
| ------------- | ------------- | ----------- | ----------- | ----------------------- | ----------- | -------------- |
| 7369 | SMITH | CLERK | 7902 | 1990-12-17 00:00:00.000 | 8000 | 20 |
| 7499 | ALLEN | SALESMAN | 7698 | 1991-02-20 00:00:00.000 | 16000 | 30 |
| 7521 | WARD | SALESMAN | 7698 | 1991-02-22 00:00:00.000 | 12500 | 30 |
| 7566 | JONES | MANAGER | 7839 | 1991-04-02 00:00:00.000 | 29750 | 20 |
| 7654 | MARTIN | SALESMAN | 7698 | 1991-09-28 00:00:00.000 | 12500 | 30 |
| 7698 | BLAKE | MANAGER | 7839 | 1991-05-01 00:00:00.000 | 28500 | 30 |
| 7782