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-12350: database link being dropped is still mounted

ORA-28046: Password change for SYS disallowed

ORA-27145: insufficient resources for requested number of processes

ORA-38309: object not purgable

PLS-00908: The stored format of string is not supported by this release

ORA-33284: (DBERR12) Analytic workspace string cannot be opened in MULTI mode before converting it by the latest version of string.

ORA-30686: no dispatcher accepted TCP/IP connection request

ORA-13456: GeoRaster cell data error

RMAN-20506: no backup of archivelog found

NNO-00612: enabling request forwarding

NID-00120: Database should be mounted exclusively

LSX-00163: duplicated content specification in "~S"

For more Oracle Errors Interview Questions Click Here