WHERE dept_id= (SELECT dept_id FROM department WHERE names=’s’);
A. Equality condition
B. Inequality condition
C. Range condition
D. All of the above
Answer:A
WHERE dept_id= (SELECT dept_id FROM department WHERE names=’s’);
A. Equality condition B. Inequality condition C. Range condition D. All of the above
Explanation: In the following query column equate to the value returned by subquery.