Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS R TYPESCRIPT ANGULAR GIT POSTGRESQL MONGODB ASP AI GO KOTLIN SASS VUE DSA GEN AI SCIPY AWS CYBERSECURITY DATA SCIENCE
     ❯   

MongoDB 聚合管道


聚合管道

聚合操作允许您对数据进行分组、排序、执行计算、分析数据等等。

聚合管道可以包含一个或多个“阶段”。这些阶段的顺序很重要。每个阶段都作用于前一个阶段的结果。

示例

db.posts.aggregate([
  // Stage 1: Only find documents that have more than 1 like
  {
    $match: { likes: { $gt: 1 } }
  },
  // Stage 2: Group documents by category and sum each categories likes
  {
    $group: { _id: "$category", totalLikes: { $sum: "$likes" } }
  }
])
自己尝试 »

示例数据

为了演示在聚合管道中使用阶段,我们将示例数据加载到我们的数据库中。

从 MongoDB Atlas 仪表板转到数据库。单击省略号并选择“加载示例数据集”。这会将多个示例数据集加载到您的数据库中。

在接下来的部分中,我们将使用此示例数据更详细地探讨几个聚合管道阶段。


×

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
[email protected]

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail:
[email protected]

W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookie and privacy policy.

Copyright 1999-2024 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.