display details of employee's who are seniour to there own manager ? ( In

display details of employee's who are seniour to there own
manager ? ( In a Emp Table )

Question Posted / subbareddy

Answers were Sorted based on User's Feedback

display details of employee's who are seniour to there own manager ? ( In a Emp Table )..

Answer / jyothi

select e.ename,e.hiredate,m.ename,m.hiredate from emp e,emp m
where e.mgr=m.empno
and e.hiredate<m.hiredate

Is This Answer Correct ?

2 Yes

0 No

display details of employee's who are seniour to there own manager ? ( In a Emp Table )..

Answer / guest

SELECT * FROM Emp GROUPBY department HAVING dateofbirth >any
(select dateofbirth FROM Emp GROUPBy department);

Is This Answer Correct ?

1 Yes

0 No

More Oracle Errors Interview Questions

ORA-00384: Insufficient memory to grow cache

PLS-00118: Duplicate group-by clause in table expression

ORA-06974: X.25 Driver: SID lookup failure

ORA-34179: (MXCHGDCL20) workspace object is not a PARTITION TEMPLATE.

ORA-29890: specified primary operator does not have an index context

ORA-07266: sppst: invalid process number passed to sppst.

TNS-04070: Cannot administer a remote Oracle Connection Manager instance which is not yet started.

QSM-02069: PCT not supported with multi-column partition key

ORA-02222: invalid PCTINCREASE storage option value

PCC-00106: RELEASE is an Oracle extension to the COMMIT and ROLLBACK statements

ORA-16117: processing

ORA-00122: cannot initialize network configuration

For more Oracle Errors Interview Questions Click Here