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-02098: error parsing index-table reference (:I)

PLS-00711: PRAGMA AUTONOMOUS_TRANSACTION cannot be declared twice

QSM-00770: the specified workload string is already referenced by task string

ORA-01891: Datetime/Interval internal error

ORA-06606: LU6.2 Driver: Unexpected response from SNA

ORA-06791: TLI Driver: poll returned error event

LFI-00005: Free some memory failed in string.

ORA-12521: TNS:listener does not currently know of instance requested in connect descriptor

ORA-10648: Tablespace SYSAUX is not offline

IMG-00855: internal image index free failed

ORA-24901: handles belonging to different environments passed into an OCI call

ORA-40213: contradictory values for settings: string, string

For more Oracle Errors Interview Questions Click Here