mongodb:SQL to Aggregation Mapping Chart

官网 http://docs.mongodb.org/manual/reference/sql-aggregation-comparison/

The  aggregation pipeline  allows MongoDB to provide native aggregation capabilities that corresponds to many common data aggregation operations in SQL.

.聚合管道允许MongoDB提供原生聚合功能,对应于许多常见的数据聚合操作SQL

The following table provides an overview of common SQL aggregation terms, functions, and concepts and the corresponding MongoDB  aggregation operators :

下表概述了常见的SQL聚合条件,功能,和概念和相应的MongoDB聚合运算符

Examples

The following table presents a quick reference of SQL aggregation statements and the corresponding MongoDB statements. The examples in the table assume the following conditions

下表提供了一个快速参考SQL聚合语句和相应的MongoDB的语句。表中的示例假定下列条件

• The SQL examples assume two tables, orders and order_lineitem that join by theorder_lineitem.order_id and the orders.id columns.

• SQL示例假设两个表,订单和order_lineitem theorder_lineitem加入的。order_id和订单。id列。
  
  

• The MongoDB examples assume one collection orders that contain documents of the following prototype:

• MongoDB示例假定一个订单集合包含文档的原型如下: