In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?

The correct answer is E. After the WHERE clause. The GROUP BY clause can be place only after the WHERE clause, or after FROM clause if there is no the WHERE clause in the statement. Incorrect Answers A: It is not possible to place the GROUP BY clause immediately after the SELECT clause. B: It is not possible to place the…

Using Functions (Single-Row, Group, Conversion, Conditional)

Question

Options

AImmediately after the SELECT clause
BBefore the WHERE clause
CBefore the FROM clause
DAfter the ORDER BY clause
EAfter the WHERE clause

How the community answered

(25 responses)

B
12% (3)
C
4% (1)
D
4% (1)
E
80% (20)

Explanation

The GROUP BY clause can be place only after the WHERE clause, or after FROM clause if there is no the WHERE clause in the statement. Incorrect Answers A: It is not possible to place the GROUP BY clause immediately after the SELECT clause. B: It is not possible to place the GROUP BY clause before the WHERE clause, it can be done C: It is not possible to place the GROUP BY clause before the FROM clause. D: It is not possible to place the GROUP BY clause after the ORDER BY clause.

Topics

#GROUP BY placement#clause ordering#WHERE vs HAVING#SELECT syntax

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice