Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


display details of employee's who are seniour to there own
manager ? ( In a Emp Table )

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

Post New Answer

More Oracle Errors Interview Questions

ORA-33072: (XSAGDNGL35) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must be specified for every relation dimensioned by that hierarchy dimension.

1 Answers  


LSX-00144: attribute "~1S" invalid derivation-restriction value "~2S"

1 Answers  


ORA-01322: No such table

1 Answers  


ORA-08269: destroy_ora_addr: cannot destroy name

1 Answers  


ORA-12622: TNS:event notifications are not homogeneous

1 Answers  






LPX-00605: Invalid attribute '~1S' in element '~2S'.

1 Answers  


DRG-11711: too much data for term string

1 Answers  


ORA-30015: previously offlined undo tablespace 'string' is still pending

1 Answers  


ORA-14183: TABLESPACE DEFAULT can be specified only for Composite LOCAL index

1 Answers  


ORA-14453: attempt to use a LOB of a temporary table, whose data has alreadybeen purged

1 Answers  


ORA-01952: system privileges not granted to 'string'

1 Answers  


QSM-02023: nested cursor

1 Answers  






Categories