In which four clauses can a sub query be used? (Choose four.)

The correct answer is A. in the INTO clause of an INSERT statement B. in the FROM clause of a SELECT statement D. in the WHERE clause of a SELECT statement E. in the SET clause of an UPDATE statement. A: a sub query is valid on the INTO clause of an ISERT Statement B: a sub query can be used in the FROM clause of a SELECT statement D: a sub query can be used in the WHERE clause of a SELECT statement, E: a sub query can be used in the SET clauses of an UPDATE statement,

Using Subqueries to Solve Queries

Question

Options

Ain the INTO clause of an INSERT statement
Bin the FROM clause of a SELECT statement
Cin the GROUP BY clause of a SELECT statement
Din the WHERE clause of a SELECT statement
Ein the SET clause of an UPDATE statement
Fin the VALUES clause of an INSERT statement

How the community answered

(34 responses)

A
74% (25)
C
9% (3)
F
18% (6)

Explanation

A: a sub query is valid on the INTO clause of an ISERT Statement B: a sub query can be used in the FROM clause of a SELECT statement D: a sub query can be used in the WHERE clause of a SELECT statement, E: a sub query can be used in the SET clauses of an UPDATE statement,

Topics

#subquery placement#INSERT#FROM clause#WHERE clause

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice