| |
GeekInterview.com > Interview Questions > Oracle
| Print | |
Question: Multi Row Sub-Queries
Answer: 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. |
| August 08, 2009 04:53:41 |
#2 |
| sen_sam86 |
Member Since: June 2008 Total Comments: 7 |
RE: Multi Row Sub-Queries
|
| 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...! |
| |
Back To Question | |
