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-10658: Lob column to be shrunk is marked unused

ORA-25267: didnt specify the signature for a reciever non-repudiable queue

LSX-00002: root element is not <schema>

ORA-31077: invalid attribute "string" specified

ORA-38774: cannot disable media recovery - flashback database is enabled

ORA-06622: LU6.2 Driver: Unable to attach to SNA

ORA-19596: SPFILE already included

QSM-02058: set operator in mv and compatibility mode is less than 9.0

ORA-09984: SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist

ORA-30157: An invalid argument was given to operating system call

ORA-25455: evaluation error for rule set: string.string, evaluation context: string.string

RMAN-08029: snapshot controlfile name set to default value: string

For more Oracle Errors Interview Questions Click Here