Question

A search condition in the ________________ clause is applied before the rows are grouped while a search condition in the _________________ clause isn’t applied until after the grouping.

Answer 1

Answer:

C). WHERE, HAVING.

Explanation:

As per the question,

'A search condition in the 'WHERE' clause is applied before the rows are grouped while a search condition in the 'HAVING' clause isn’t applied until after the grouping.

'WHERE' clause is employed to define a particular search condition that aids in filtering the rows that are an outcome of 'FROM' clause while 'HAVING' clause helps in filtering the records that lays emphasis on producing results of summarized groups. Thus, it cannot be applied until the results characterize the 'HAVING' criteria.