Oracle 练习 039

1. 题目

查询出 KING 所在部门的工作年限最大的员工名字

2. 实例

点我看答案
select e.ename, e.hiredate, e.deptno
from emp e
where e.hiredate = (
  select min(hiredate)
  from emp
  where deptno in (
    select deptno
    from emp
    where ename = 'KING'
  )
) and e.deptno = (
  select deptno
  from emp
  where ename = 'KING'
);
© 2021 刘士. All rights reserved.

结果匹配 ""

    没有匹配的结果 ""