Oracle 练习

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'
);
© 2022 刘士. All rights reserved.

结果匹配 ""

    没有匹配的结果 ""