 Related Questions Latest Answer : select from where mod(,2)0 ... Read Answers (3) | Asked by : Sudhir 1. Queris for Nth maximum Nth row?2. In One table there are 5 fields. empno, ename, deptcd, managr_id, salary.Select the departments whoose sum of the salary greater than the sum of salaries of any department?3. When index will be usd in the Query? Read Answers (7) | Asked by : DEBPROSAD BANERJEE Explain how Oracle 9i offers a comprehensive high performance infrastructure for e-business. What infrastructure here means? View Question | Asked by : raj Latest Answer : It seems that, if the main query selects from a great number of rows, than Oracle will have a better execution plan if you use EXISTS. If the main query selects from a small number of rows, while the subquery is heighly selective, then you the ... What is the actual processing being done at backend or server side to retrive the data or complete the DML operation. Query 1.
SELECT sal FROM emp e WHERE sal < any (SELECT sal FROM empWHERE empno=e.mgr)
(o/p:11 row)
Query 2.
SELECT SAL FROM emp e WHERE sal < any (SELECT sal FROM empWHERE mgr=e.empno)
(o/p:1 Latest Answer : 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...! ... Which one gives better performance,
co-related subquery or inline views? Why? Latest Answer : Inline views works better than correlated subqueries in 8i. But things have changed in 9i. This is because Oracle has changed their logic while processing a correlated subquery. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
