View previous topic :: View next topic
|
Author |
Message |
learnmf
Active User
Joined: 14 Mar 2005 Posts: 123
|
|
|
|
Hi friends
I have a query.
There is a table contain
Code: |
EMPNO EMPNAME MGR HIREDATE
|
In the above table i have to find out the name of those employee whose joining date is less then their manager.
Thanks
Chandra |
|
Back to top |
|
|
rssomm
New User
Joined: 05 Jun 2005 Posts: 41 Location: Hyderabad
|
|
|
|
Please try this
Select * from Emp E where hiredate > ( select hiredate from E where EMPNO=E.MGR)
Madhu |
|
Back to top |
|
|
rssomm
New User
Joined: 05 Jun 2005 Posts: 41 Location: Hyderabad
|
|
|
|
Sorry.. ignore my earlier reply. Please use the following.
Select * from Emp E where hiredate < ( select hiredate from Emp where EMPNO=E.MGR)
or
Select E.Ename Employee, E.HIREDATE , M.ename MANAGER, M.HIREDATE from EMP E, EMP M Where E.MGR = M.EMPNO and E.HIREDATE < M.HIREDATE;
Madhu |
|
Back to top |
|
|
gowtham_srgp
New User
Joined: 09 Jun 2005 Posts: 38
|
|
|
|
learnmf wrote: |
Hi friends
I have a query.
There is a table contain
Code: |
EMPNO EMPNAME MGR HIREDATE
|
In the above table i have to find out the name of those employee whose joining date is less then their manager.
Thanks
Chandra |
hai.....
SELECT EMPNAME,MGR FROM EMPDATA.X WHERE HIREDATE.X < ALL
( SELECT HIREDATE.Y FROM EMPDATA WHERE MGR.Y = MGR.X)
hope this helps you. corrections welcomed.........
gowtham |
|
Back to top |
|
|
|