Question

SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.

(a) Group by

(b) With

(c) Where

(d) Having

I got this question in an online quiz.

My doubt stems from Aggregation of Data topic in section Laying the Foundation of SQL Server

Answer 1

Correct answer is (b) With

To explain I would say: The with clause provides a way of defining a temporary relation whose definition is available only to the query in which the with clause occurs.