Multi Row Sub-Queries

Query 1.
SELECT sal FROM emp e WHERE sal < any (SELECT sal FROM emp
WHERE empno=e.mgr)
(o/p:11 row)

Query 2.
SELECT SAL FROM emp e WHERE sal < any (SELECT sal FROM emp
WHERE mgr=e.empno)
(o/p:1 row)

What is the difference between the above 2 queries.

svp.kiran
Profile Answers by svp.kiran Questions by svp.kiran
Sep 28th, 2008
2
3849

Questions by svp.kiran

Oracle

Answer

Showing Answers 1 - 2 of 2 Answers

todeepakmalhotra
Profile Answers by todeepakmalhotra Questions by todeepakmalhotra

Sep 30th, 2008

These both are correlated subqueries.

In the first one, we are knowing the salaries of employees who are earning less than there manager.

In the second one we are knowing about the salaries of managers who are earning less than their employees whom they manage.

sen_sam86
Profile Answers by sen_sam86

Aug 27th, 2009

how this query is possible i dont know, how the emp number and manager number will be same, i think the query in meaning less r am not understanding properly i dont know,,,, Let some one explain this...!