Explanation:With clause creates a temporary relation. 7. Subqueries cannot:
A. Use group by or group functions
B. Retrieve data from a table different from the one in the outer query
C. Join tables
D. Appear in select, update, delete, insert statements.
Answer:A
Explanation:With clause creates a temporary relation. 7. Subqueries cannot:
A. Use group by or group functions B. Retrieve data from a table different from the one in the outer query C. Join tables D. Appear in select, update, delete, insert statements.
Explanation:None. 8. Which of the following is not a aggregate function ?