1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
|
update emp set hiredate = null where empno = 7369;
SELECT
d.deptno
,d.dname
,e.hiredate
FROM
dept d, emp e
WHERE
d.deptno = e.deptno(+)
AND EXISTS
( SELECT NULL
FROM emp e2
WHERE e.deptno = e2.deptno
HAVING MAX(e2.hiredate) = e.hiredate
OR e.hiredate IS NULL
)
;
20 RESEARCH
30 SALES 03/12/1981 00:00:00
10 ACCOUNTING 23/01/1982 00:00:00
20 RESEARCH 08/08/2012 15:05:19
40 ORACLE
SELECT
d.deptno
,d.dname
,e.hiredate
FROM
dept d, emp e
WHERE
d.deptno = e.deptno(+)
AND EXISTS
( SELECT NULL
FROM emp e2
WHERE e.deptno = e2.deptno
HAVING MAX(e2.hiredate) = e.hiredate
OR e.empno IS NULL
)
;
30 SALES 03/12/1981 00:00:00
10 ACCOUNTING 23/01/1982 00:00:00
20 RESEARCH 08/08/2012 15:05:19
40 ORACLE |
Partager