4. Count the documents grouped by a field and sorted by count

Moreover, we can count the number of documents in a collection grouped by a field and sort them by the count in a specific order.

In the following query, we used the $group operator to group the documents by the specified field course . We have used the $sum operator to count the number of documents in each group, storing the count in a count field. After that, depending on the field count, the $sort operator arranges the outcomes in descending order.

#Counting documents number in a collection
db.student.aggregate([
  { $group: {
    _id: "$course",
    count: { $sum: 1 }
  { $sort: { count: -1 } }
The output showed each document contains the _id field which has a value of the grouped field course. Also, the count field contains the count of documents in the group, sorted by the count in descending order.
5. Count Distinct Values
Now, there might be a case when we want to count the number of distinct values in the orders collection. We must employ the subsequent query to accomplish this. 
Here, we first group the documents by the name field to get the distinct student names. Then, it groups the distinct student names by a null value to count the total number of distinct names. After that, the _id field as null and the count field as the number of distinct names will be returned.
#Counting distinct values
db.student.aggregate([
  { $group: { _id: "$name" } },
  { $group: { _id: null, count: { $sum: 1 } } }
The output is obtained for counting the occurrence of distinct values by the group field. 
6. Conclusion
In conclusion, we explored how we get the SELECT COUNT GROUP BY equivalent in MongoDB with different examples. By using this statement, we can quickly and efficiently count the number of documents in a collection based on specific fields and conditions
More details about this topic can be found here.
You may also like reading:

MongoDB Find Objects Between two Dates
MongoDB Change all array elements in a document to a certain value
Secure MongoDB with Username and Password
MongoDB Find records where the array field is empty
E11000 duplicate key error index in MongoDB
MongoDB Add a New Field to All Documents
Import JSON file Using mongoimport command in MongoDB
MongoDB Put an Image File in a JSON Object
MongoDB insert if not exists
Update Objects in the Array in MongoDB
Leave a Reply Cancel reply
Comment</div><div class="comment-form-author"><label for="author" class="screen-reader-text">Enter your name or username to comment</label><input type="text" name="author" id="author" value="" placeholder="Name (required)" size="22" tabindex="0" aria-required="true" class="input-name"/></div>
<div class="comment-form-email"><label for="email" class="screen-reader-text">Enter your email address to comment</label><input type="text" name="email" id="email" value="" placeholder="Email (required)" size="22" tabindex="0" aria-required="true" class="input-email"/></div>
<div class="comment-form-url"><label for="url" class="screen-reader-text">Enter your website URL (optional)</label><input type="text" name="url" id="url" value="" placeholder="Website" size="22" tabindex="0" class="input-website"/></div>
<p class="comment-form-cookies-consent"><input id="wp-comment-cookies-consent" name="wp-comment-cookies-consent" type="checkbox" value="yes"/> <label for="wp-comment-cookies-consent">Save my name, email, and website in this browser for the next time I comment.</label></p>
<div id="ocean_custom_menu-41" class="sidebar-box widget-oceanwp-custom-menu custom-menu-widget clr"><style type="text/css">.ocean_custom_menu-41 > ul > li > a, .custom-menu-widget .ocean_custom_menu-41 .dropdown-menu .sub-menu li a.menu-link{color:#003591;}.custom-menu-widget .ocean_custom_menu-41.oceanwp-custom-menu > ul.click-menu .open-this{color:#003591;}.ocean_custom_menu-41 > ul > li > a:hover, .custom-menu-widget .ocean_custom_menu-41 .dropdown-menu .sub-menu li a.menu-link:hover{color:#2cb1f4;}.custom-menu-widget .ocean_custom_menu-41.oceanwp-custom-menu > ul.click-menu .open-this:hover{color:#2cb1f4;}</style><h4 class="widget-title">MongoDB Tutorial</h4><div class="oceanwp-custom-menu clr ocean_custom_menu-41 left dropdown-hover"><ul id="menu-mongodb-tutorial" class="dropdown-menu sf-menu"><li id="menu-item-71441" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-71441"><a href="https://sparkbyexamples.com/mongodb-tutorial-with-examples/" class="menu-link">MongoDB Introduction</a></li>
<li id="menu-item-71451" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71451"><a href="https://sparkbyexamples.com/mongodb/run-mongodb-as-a-window-service/" class="menu-link">MongoDB Run as Window Service</a></li>
<li id="menu-item-71442" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71442"><a href="https://sparkbyexamples.com/mongodb/run-mongodb-in-docker-container/" class="menu-link">MongoDB Run in Docker Container</a></li>
<li id="menu-item-71438" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71438"><a href="https://sparkbyexamples.com/mongodb/working-with-mongodb-shell/" class="menu-link">MongoDB mongosh Shell</a></li>
<li id="menu-item-80380" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-80380"><a href="https://sparkbyexamples.com/mongodb/basic-commands-of-mongodb/" class="menu-link">Basic MongoDB Commands</a></li>
<li id="menu-item-71444" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71444"><a href="https://sparkbyexamples.com/mongodb/cassandra-vs-mongodb-differences/" class="menu-link">MongoDB vs Cassandra Differences</a></li>
<li id="menu-item-71446" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71446"><a href="https://sparkbyexamples.com/mongodb/mongodb-vs-postgresql-differences/" class="menu-link">MongoDB Vs SQL Differences</a></li>
<li id="menu-item-72626" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-72626"><a href="https://sparkbyexamples.com/mongodb/mongodb-create-database/" class="menu-link">MongoDB Create Database & Collection</a></li>
<li id="menu-item-80630" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-80630"><a href="https://sparkbyexamples.com/mongodb/mongodb-insertone-insertmany-documents/" class="menu-link">MongoDB insertOne() & insertMany() Documents</a></li>
<li id="menu-item-71482" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71482"><a href="https://sparkbyexamples.com/mongodb/mongodb-insert-if-not-exists/" class="menu-link">MongoDB insert if not exists</a></li>
<li id="menu-item-71439" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71439"><a href="https://sparkbyexamples.com/mongodb/mongodb-findone-explained-by-examples/" class="menu-link">MongoDB findOne()</a></li>
<li id="menu-item-71440" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71440"><a href="https://sparkbyexamples.com/mongodb/mongodb-db-collection-find-with-examples/" class="menu-link">MongoDB find()</a></li>
<li id="menu-item-71452" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71452"><a href="https://sparkbyexamples.com/mongodb/query-nested-objects-in-mongodb/" class="menu-link">MongoDB Query Nested Objects</a></li>
<li id="menu-item-71470" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71470"><a href="https://sparkbyexamples.com/mongodb/mongodb-add-a-new-field-to-all-documents/" class="menu-link">MongoDB Add a New Field to All Documents</a></li>
<li id="menu-item-72627" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-72627"><a href="https://sparkbyexamples.com/mongodb/mongodb-updateone-method-explained/" class="menu-link">MongoDB updateOne()</a></li>
<li id="menu-item-71480" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71480"><a href="https://sparkbyexamples.com/mongodb/mongodb-update-field-using-value-from-another-field/" class="menu-link">MongoDB Update Field using Value from Another Field</a></li>
<li id="menu-item-71479" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71479"><a href="https://sparkbyexamples.com/mongodb/mongodb-update-multiple-documents/" class="menu-link">MongoDB Update Multiple Documents</a></li>
<li id="menu-item-80402" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-80402"><a href="https://sparkbyexamples.com/mongodb/mongodb-delete-documents-from-collection/" class="menu-link">MongoDB Delete Documents</a></li>
<li id="menu-item-71449" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71449"><a href="https://sparkbyexamples.com/mongodb/mongodb-sort-documents-in-a-collection/" class="menu-link">MongoDB Sort Documents</a></li>
<li id="menu-item-71450" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71450"><a href="https://sparkbyexamples.com/mongodb/mongodb-sql-join-with-examples/" class="menu-link">MongoDB Join Documents</a></li>
<li id="menu-item-80559" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-80559"><a href="https://sparkbyexamples.com/mongodb/mongodb-distinct-get-unique-values-from-field/" class="menu-link">MongoDB distinct()</a></li>
<li id="menu-item-71437" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71437"><a href="https://sparkbyexamples.com/mongodb/mongodb-group-aggregation/" class="menu-link">MongoDB aggreaget() to Group</a></li>
<li id="menu-item-71481" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71481"><a href="https://sparkbyexamples.com/mongodb/mongodb-group-by-multiple-fields/" class="menu-link">MongoDB Group by Multiple Fields</a></li>
<li id="menu-item-80558" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-80558"><a href="https://sparkbyexamples.com/mongodb/mongodb-transaction/" class="menu-link">MongoDB Transactions</a></li>
<li id="menu-item-71477" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71477"><a href="https://sparkbyexamples.com/mongodb/import-json-file-using-the-mongoimport-command/" class="menu-link">MongoDB Import JSON file</a></li>
<li id="menu-item-71478" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71478"><a href="https://sparkbyexamples.com/mongodb/import-csv-file-using-mongoimport-in-mongodb/" class="menu-link">MongoDB Import CSV file</a></li>
<li id="menu-item-71443" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71443"><a href="https://sparkbyexamples.com/mongodb/mongodb-push-operator-to-update-array/" class="menu-link">MongoDB $push Operator</a></li>
<li id="menu-item-71448" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71448"><a href="https://sparkbyexamples.com/mongodb/unwind-in-mongodb-explained/" class="menu-link">MongoDB $unwind</a></li>
<li id="menu-item-71445" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71445"><a href="https://sparkbyexamples.com/mongodb/mongodb-node-js-driver/" class="menu-link">MongoDB Node js Driver</a></li>
<li id="menu-item-71447" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71447"><a href="https://sparkbyexamples.com/mongodb/mongodb-pymongo-python-package/" class="menu-link">MongoDB pymongo Python Package</a></li>
<li id="menu-item-80403" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-80403"><a href="https://sparkbyexamples.com/mongodb/install-mongodb-on-ubuntu/" class="menu-link">Install MongoDB On Ubuntu</a></li>
</ul></div></div><div id="ocean_custom_menu-40" class="sidebar-box widget-oceanwp-custom-menu custom-menu-widget clr"><style type="text/css">.ocean_custom_menu-40 > ul > li > a, .custom-menu-widget .ocean_custom_menu-40 .dropdown-menu .sub-menu li a.menu-link{color:#003591;}.custom-menu-widget .ocean_custom_menu-40.oceanwp-custom-menu > ul.click-menu .open-this{color:#003591;}.ocean_custom_menu-40 > ul > li > a:hover, .custom-menu-widget .ocean_custom_menu-40 .dropdown-menu .sub-menu li a.menu-link:hover{color:#2cb1f4;}.custom-menu-widget .ocean_custom_menu-40.oceanwp-custom-menu > ul.click-menu .open-this:hover{color:#2cb1f4;}</style><h4 class="widget-title">MongoDB Most Used Examples</h4><div class="oceanwp-custom-menu clr ocean_custom_menu-40 left dropdown-hover"><ul id="menu-mongodb-most-used-examples" class="dropdown-menu sf-menu"><li id="menu-item-64976" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-64976"><a href="https://sparkbyexamples.com/mongodb/mongodb-query-like/" class="menu-link">MongoDB Query with “like” Example</a></li>
<li id="menu-item-65060" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-65060"><a href="https://sparkbyexamples.com/mongodb/mongodb-find-objects-between-two-dates/" class="menu-link">MongoDB Find Objects Between two Dates</a></li>
<li id="menu-item-65490" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-65490"><a href="https://sparkbyexamples.com/mongodb/mongodb-check-if-a-field-contains-a-string/" class="menu-link">MongoDB Check if a Field Contains a String</a></li>
<li id="menu-item-64724" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-64724"><a href="https://sparkbyexamples.com/mongodb/mongodb-update-field-using-value-from-another-field/" class="menu-link">MongoDB Update Field using Value from Another Field</a></li>
<li id="menu-item-71463" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71463"><a href="https://sparkbyexamples.com/mongodb/mongodb-get-the-last-n-records-from-the-collection/" class="menu-link">MongoDB Get the Last N Records</a></li>
<li id="menu-item-71465" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71465"><a href="https://sparkbyexamples.com/mongodb/search-object-by-its-objectid-in-mongo-console/" class="menu-link">MongoDB Search Object by its ObjectId</a></li>
<li id="menu-item-71464" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71464"><a href="https://sparkbyexamples.com/mongodb/mongodb-query-where-array-size-is-greater-than-1/" class="menu-link">MongoDB Query Where Array Size is Greater than 1</a></li>
<li id="menu-item-64725" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-64725"><a href="https://sparkbyexamples.com/mongodb/retrieve-queried-element-in-an-object-array-in-mongodb/" class="menu-link">MongoDB Retrieve Element in an Object Array</a></li>
<li id="menu-item-65489" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-65489"><a href="https://sparkbyexamples.com/mongodb/mongodb-change-all-array-elements-in-a-document-to-a-certain-value/" class="menu-link">MongoDB Change all array elements in a document to a certain value</a></li>
<li id="menu-item-64978" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-64978"><a href="https://sparkbyexamples.com/mongodb/mongodb-update-multiple-array-elements/" class="menu-link">MongoDB Update Multiple Array Elements</a></li>
<li id="menu-item-71466" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71466"><a href="https://sparkbyexamples.com/mongodb/mongodb-select-single-field-from-documents-in-a-collection/" class="menu-link">MongoDB Select Single Field from Documents in a Collection</a></li>
<li id="menu-item-71467" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71467"><a href="https://sparkbyexamples.com/mongodb/mongodb-find-records-where-the-array-field-is-empty/" class="menu-link">MongoDB Find records where the array field is empty</a></li>
<li id="menu-item-71468" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71468"><a href="https://sparkbyexamples.com/mongodb/mongodb-query-dates-by-using-isodate/" class="menu-link">MongoDB Query Dates by using ISODate</a></li>
<li id="menu-item-71469" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71469"><a href="https://sparkbyexamples.com/mongodb/mongodb-query-using-dates/" class="menu-link">MongoDB Query Using Dates</a></li>
<li id="menu-item-64726" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-64726"><a href="https://sparkbyexamples.com/mongodb/how-to-use-ifnull-operator-in-mongodb/" class="menu-link">MongoDB Using $ifNull Operator</a></li>
<li id="menu-item-65059" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-65059"><a href="https://sparkbyexamples.com/mongodb/mongodb-relationships-embed-or-reference/" class="menu-link">MongoDB Embedded or Reference Relationships</a></li>
<li id="menu-item-71471" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71471"><a href="https://sparkbyexamples.com/mongodb/mongodb-combine-data-from-multiple-collections/" class="menu-link">MongoDB Combine data from Multiple Collections</a></li>
<li id="menu-item-71472" class="menu-item menu-item-type-post_type menu-item-object-post current-menu-item menu-item-71472"><a href="https://sparkbyexamples.com/mongodb/mongodb-equivalent-of-select-count-group-by/" class="menu-link">MongoDB Equivalent of SELECT COUNT GROUP BY</a></li>
<li id="menu-item-71473" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71473"><a href="https://sparkbyexamples.com/mongodb/mongodb-query-case-insensitive/" class="menu-link">MongoDB Query Case Insensitive</a></li>
<li id="menu-item-71474" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71474"><a href="https://sparkbyexamples.com/mongodb/mongodb-remove-file-from-the-document/" class="menu-link">MongoDB Remove File from the Document</a></li>
<li id="menu-item-71475" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71475"><a href="https://sparkbyexamples.com/mongodb/store-images-in-the-mongodb-database/" class="menu-link">MongoDB Store images in the Document</a></li>
<li id="menu-item-71476" class="menu-item menu-item-type-post_type menu-item-object-post menu-item-71476"><a href="https://sparkbyexamples.com/mongodb/mongodb-put-an-image-file-in-a-json-object/" class="menu-link">MongoDB Put an Image File in a JSON Object</a></li>
<div class="oceanwp-about-me-text clr">SparkByExamples.com is a Big Data and Spark examples community page, all examples are simple and easy to understand, and well tested in our development environment <a href="https://sparkbyexamples.com/about-sparkbyexamples/">Read more ..</a></div>
<li class="facebook"><a href="https://www.facebook.com/sparkbyexamples " aria-label="Facebook" target="_blank" rel="noopener noreferrer"><i class=" fab fa-facebook" aria-hidden="true" role="img"/></a><span class="screen-reader-text">Opens in a new tab</span></li><li class="instagram"><a href="https://instagram.com/sparkbyexamples " aria-label="Instagram" target="_blank" rel="noopener noreferrer"><i class=" fab fa-instagram" aria-hidden="true" role="img"/></a><span class="screen-reader-text">Opens in a new tab</span></li><li class="linkedin"><a href="https://www.linkedin.com/company/sparkbyexamples/ " aria-label="LinkedIn" target="_blank" rel="noopener noreferrer"><i class=" fab fa-linkedin" aria-hidden="true" role="img"/></a><span class="screen-reader-text">Opens in a new tab</span></li><li class="pinterest"><a href="https://pinterest.com/sparkbyexamples " aria-label="Pinterest" target="_blank" rel="noopener noreferrer"><i class=" fab fa-pinterest-p" aria-hidden="true" role="img"/></a><span class="screen-reader-text">Opens in a new tab</span></li><li class="twitter"><a href="https://twitter.com/sparkbyexamples " aria-label="Twitter" target="_blank" rel="noopener noreferrer"><i class=" fab fa-twitter" aria-hidden="true" role="img"/></a><span class="screen-reader-text">Opens in a new tab</span></li>