$limit (Limit)

Last updated: 2026-10-09

$limit (Limit)

$limit truncates the pipeline to the first N documents in the current order, changing only the count, not the content. Combined with $sort it implements top-N queries. Placing $limit early slashes the data later stages must process — a common optimization.

CategoryCore Stages
MongoDB Version1.0+
Example Languagemongosh (Shell)

📝 Syntax

{ $limit: <positive integer> }

⚙️ Parameters

countNumber of documents to keep; must be a positive integer.

Returns:Document stream limited to the first N documents

▶ Example

Run the commands below in your local mongosh (requires a running mongod):

// $limit: top 5 articles by views
db.articles.aggregate([
  { $sort: { views: -1 } },
  { $limit: 5 }
])

Output:

// The 5 most-viewed articles

📌 Notes

📚 Related Tutorials

❓ FAQ

QCan $limit and $skip be used together?
AYes. $skip drops the first N documents, then $limit truncates — offset plus limit pagination.
QIs it useful to place $limit early?
AYes. The earlier the truncation, the less data later stages process.
QCan $limit take a variable argument?
ANo, it must be a literal positive integer; use a $facet sub-pipeline for dynamic counts.
Web-Tutorial.com

Web-Tutorial Tech Team

A team of developers maintaining programming tutorials. Each tutorial is written and reviewed by developers with expertise in that field. We work to keep our content accurate and reliable — if you spot an issue, please let us know.

100%

🙏 帮我们做得更好

我们是刚上线的编程教程站,几个人的小团队,精力有限。页面虽经检查,难免还有疏漏——链接失效、排版错乱、内容有误、语言生硬……

如果您发现了,麻烦告诉我们,我们会在收到反馈后第一时间进行修复,再次感谢您的光临 🙏