Where can sub queries be used? (Choose all that apply)

The correct answer is A. field names in the SELECT statement B. the FROM clause in the SELECT statement C. the HAVING clause in the SELECT statement F. the WHERE clause in SELECT as well as all DML statements. SUBQUERIES can be used in the SELECT list and in the FROM, WHERE, and HAVING clauses A subquery can have any of the usual clauses for selection and projection. The following are required clauses: The following are optional clauses: The subquery (or subqueries) within a…

Using Subqueries to Solve Queries

Question

Options

Afield names in the SELECT statement
Bthe FROM clause in the SELECT statement
Cthe HAVING clause in the SELECT statement
Dthe GROUP BY clause in the SELECT statement
Ethe WHERE clause in only the SELECT statement
Fthe WHERE clause in SELECT as well as all DML statements

How the community answered

(35 responses)

A
74% (26)
D
17% (6)
E
9% (3)

Explanation

SUBQUERIES can be used in the SELECT list and in the FROM, WHERE, and HAVING clauses A subquery can have any of the usual clauses for selection and projection. The following are required clauses: The following are optional clauses: The subquery (or subqueries) within a statement must be executed before the parent query that calls it, in order that the results of the subquery can be passed to the parent.

Topics

#subqueries#WHERE clause#HAVING clause#FROM clause

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice