Find and count in the same query in MongoDB

Question

How exactly would one use the MongoDB aggregate function to get the same result as the following MySQL query?

sqlite> SELECT company, COUNT(*), MAX(salary) FROM Employees GROUP BY company;

See if this helps: stackoverflow.com/a/13275889/2554537 or tutorialspoint.com/perform-min-max-with-mongodb-aggregation — zedfoxus
– zedfoxus, Commented Mar 7, 2021 at 15:18
You will find this SQL to Aggregation Mapping Chart useful to translate your SQL query to MongoDB query. — prasad_
– prasad_, Commented Mar 8, 2021 at 4:51

vishnu · Accepted Answer · 2021-03-07 15:48:12Z

0

You can try something like

db.collection.aggregate([
  { $group: { _id: "$company", count: { $sum: 1 }, max: { $max: "$salary" } } },
  { $project: { _id: 0, company: "$_id", count: 1, max: 1 } },
]);

$project stage is added at the end of the pipeline for just renaming the _id field to company in the final output

answered Mar 7, 2021 at 15:48

vishnu

2,0112 gold badges10 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Find and count in the same query in MongoDB

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related