MongoDB聚合管道与SQL子句相对比

SQL

MongoDB Operators

where

$match

group by

$group

having

$match

select

$project

order by

$sort

limit

$limit

sum

$sum

count

$sum

join

$look up

 

$skip - 跳过几条记录显示