MongoDB compass simple group by query

user_305135 0
Viewed 9135

How can I run such an SQL query in MongoDB Compass?

select subject,count(*) from books group by subject
mongodb-compass mongodb nosql
1 Answers

you can use Mongodb Aggregation pipeline with $group with $sum to achieve this.

Try : 

db.collection_name.aggregate([{
    $group : {
        _id : "$subject",
        subject : {$first : "$subject"},
        count : {$sum : 1}
    }
}])
user_50840000
Related