Limit the no of rows in MongoDB or Use Limit with find (select )

Limit the no of rows return in MongoDB

In following example we have to limit the no of rows return to 5. In this employees table

-- In SQL Query
SELECT * FROM employees LIMIT 5

-- In MongoDB
db.employees.find().limit(5)

We can also skip in SQL query and get another rows, we also used this concept in paging of data.
In following example we skip 10 rows and query return next 4 rows.

-- In SQL
SELECT * FROM employees LIMIT 5 SKIP 10
-- In MongoDB
db.employees.find().limit(5).skip(10)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.