Question

____________ works similar to HAVING clause in SQL.

(a) $setcon

(b) $group

(c) $match

(d) None of the mentioned

The question was asked during an online interview.

I would like to ask this question from SQL to Aggregation Mapping Chart topic in chapter Aggregation Concepts and Aggregation Mechanics of MongoDB

Answer 1

Correct answer is (c) $match

To elaborate: Place the $match as early in the aggregation pipeline as possible.