SQL Query to display the EMPNO, ENAME, JOB, HIREDATE, EXP of all Managers

SELECT EMPNO,
       ENAME,
       JOB,
       HIREDATE,
       MONTHS_BETWEEN(SYSDATE,HIREDATE) EXP
FROM EMP
WHERE EMPNO IN
    (SELECT MGR
     FROM EMP);

Comments

Popular posts from this blog

Top myths for NULL value in SQL Queries