Category Archives: MongoDB

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

Limit the no of rows returns 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)