A subquery is a query that is nested inside a SELECT , INSERT , UPDATE , or DELETE statement, or inside another subquery. ... A subquery can be used anywhere an expression is allowed. In this example ...

/* What is a sub-query? How does sql process a statement containing sub-query? Question: Find the employees who's salary is more than the average salary earned by all employees /* Find the average ...

Note: This example uses a Version 6 view descriptor with the Pass-Through Facility to access DBMS data. Beginning in Version 7, you can associate a libref directly with your DBMS data and use the ...