display details of employee's who are seniour to there own
manager ? ( In a Emp Table )
Answers were Sorted based on User's Feedback
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 |
Answer / guest
SELECT * FROM Emp GROUPBY department HAVING dateofbirth >any
(select dateofbirth FROM Emp GROUPBy department);
Is This Answer Correct ? | 1 Yes | 0 No |
ORA-01257: cannot reuse database file string, unknown file size
RMAN-08512: waiting for snapshot controlfile enqueue
O2I-00130: Invalid Java file name
ORA-25242: cannot change subscriber name from string to string without FIRST_MESSAGE option
PLS-00230: OUT and IN OUT formal parameters may not have default expressions
ORA-06702: TLI Driver: cannot allocate context area
TNS-04020: CMCTL Version: number.number.number.number.number
ORA-25153: Temporary Tablespace is Empty
DRG-52203: invalid object name: string
TNS-00002: INTCTL: error while starting the Interchange
ORA-12629: TNS:no event test
IMG-00842: image index allocation failed