Which clause specifies field criteria that must be met by each record to be included in the results?

• A. Where
• B. Group By
• C. Having
• D. From

Answer: (A)

Filtering rows to include only those that meet specific conditions is done with the WHERE clause. It applies a predicate to every row as the query runs, so only records that satisfy the criteria are carried forward to the rest of the processing (before any grouping or aggregation). For example, SELECT id, amount FROM orders WHERE amount > 100; will return only orders where the amount exceeds 100.

Group By, in contrast, collects rows into groups based on shared values in one or more columns to enable aggregation. Having then filters those groups after aggregation has occurred. From simply specifies the data source (which table or tables the query reads from) and doesn’t filter individual rows.