How do I multiple second batch query (skip) on MongoDB if there's no numeric row index

Question

Usually I did this

db.flat_transaction.find({},{"customer_id": 1,"item": 1, "_id":0}).limit(3000000)

But, I want to query the 3000001-6000000 entry , 6000001-9000000entry, etc.

How suppose I do this?

Answer 1

Use MongoDB Skip

db.flat_transaction.find({},{"customer_id": 1,"item": 1, "_id":0}).skip(3000000).limit(3000000)