SQL Query

learnmf · Active User Joined: 14 Mar 2005 Posts: 124

Hi friends

I have a query.

There is a table contain

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

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

gowtham_srgp · New User Joined: 09 Jun 2005 Posts: 38