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-29861: domain index is marked LOADING/FAILED/UNUSABLE

TNS-12535: TNS:operation timed out

TNS-01053: Connecting to string

NNL-01073: Administrative region description: string

ORA-19040: Element string does not match expected string.

EXP-00022: must be SYS or SYSTEM to do incremental export

QSM-02143: SUM(expr) without COUNT(expr)

ORA-16151: Managed Standby Recovery not available

ORA-30200: Wrong NLS item was passed into OCINlsGetInfo()

PROC-00006: User does not have permission to perform a cluster registry operation on this key.

ORA-29374: resource plan string in top-plan string has no plan directives

ORA-14607: Tablespace was not specified for previous subpartitions in template but is specified for string

For more Oracle Errors Interview Questions Click Here