mongodb get first element after find query [duplicate]

Question

I can't find the answer. I have a query that can return many answer and I want to get the last one. How to do it?

db.users.find({username: "bob", sort: {createdAt: -1}}).first()

I would like something like this.

The reply and "duplicate" are what you're asking, right? You can do this: db.collection.find({ username: "bob" }).sort({ createdAt: -1 }).limit(1).toArray()[0] — Felipe Zavan
– Felipe Zavan, Commented Jul 11, 2024 at 10:18

Pratik Gujarathi · Accepted Answer · 2015-09-20 15:28:12Z

0

do this to get last N records :

function last(N) {
    return db.collection.find().skip(db.collection.count() - N);
}

answered Sep 20, 2015 at 15:28

Pratik Gujarathi

9651 gold badge11 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1