Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 )

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

LCD-00112: illegal integer radix specification [string]

1 Answers  


ORA-12688: Login failed: the SecurID server rejected the new pincode

1 Answers  


PCC-00023: Unable to log off from ORACLE

1 Answers  


RMAN-08115: channel string: restoring SPFILE

1 Answers  


SQL*Loader-00273: READBUFFERS may be used only in direct path.

1 Answers  


ORA-16081: insufficient number of processes for APPLY

1 Answers  


PLS-00233: function name used as an exception name in when clause

1 Answers  


ORA-14619: resulting List subpartition(s) must contain at least 1 value

1 Answers  


ORA-06748: TLI Driver: cannot allocate t_discon

1 Answers  


ORA-07801: slbtpd: invalid exponent

1 Answers  


O2F-00320: Invalid filename for the OUTTYPE file

1 Answers  


ORA-24397: error occured while trying to free connections

1 Answers  


Categories