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

DRG-12406: invalid CTX EXEC tag attribute (string)

DRG-11303: secondary indexes are not supported by this indextype

NNL-00401: Authoritative answer: string

ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable

DRG-11829: Gone

ORA-00385: cannot enable Very Large Memory with new buffer cache parameters

NNO-00112: line string: ignored duplicate data of type "string"

ORA-39120: Table string can't be truncated, data will be skipped. Failing error is: string

ORA-36912: (XSAGDNGL48) In AGGMAP workspace object, MODEL workspace object cannot be simultaneous.

ORA-24410: scrollable cursor max size exceeded

ORA-07588: spdcr: $GETJPIW get image name failure

PLS-01507: DROP is non-ANSI

For more Oracle Errors Interview Questions Click Here