|
SUBQUERY
A query result used in a condition of a where clause.Such a query is called as SUBQUERY. The complete statement from select statement is called as NESTED QUERY.
Syntax ::
<EXPRESSION>[NOT] IN (<SUBQUERY>)
<EXPRESSION><COMPARISON OPERATOR> [ANY | ALL ] (<SUBQUERY>)
Example ::
SELECT * FROM CUSTOMERS
WHERE CUST_ID IN
(SELECT EMPID FROM EMPLOYEE)
|
|
