Interested to Buy Any Domain ? << Click Here >> for more details...
display details of employee's who are seniour to there own
manager ? ( In a Emp Table )
- 2 Answers
- 5041 Views
- I also Faced
- E-Mail Answers
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 |
NNL-00201: Shutdown occurs in string
ORA-31208: DBMS_LDAP: PL/SQL - Invalid LDAP Message.
ORA-31016: Attempted to delete entry without name
PLS-01411: Use of 'REM' token
ORA-01030: SELECT ... INTO variable does not exist
ORA-02295: found more than one enable/disable clause for constraint
ORA-13204: failed to create spatial index table
ORA-31627: API call succeeded but more information is available
ORA-28545: error diagnosed by Net8 when connecting to an agent
RMAN-06486: changed backup piece expired
ORA-14045: only one partition may be modified
QSM-01113: HAVING clause of mv, string, is more restrictive than query
Oracle Errors 
