📊
Querying & Filtering

Sorting & Limiting

sort, limit, skip
💡 Sorting/limiting, EK, "TOP, 10, LIST" banaне, jaisa, hai — SAARE, ITEMS, ko, ORDER, mein, LAGAKE, (sort), SIRF, PEHLE, FEW, (limit) DIKHAТE, HO, aur, PAGINATION, ke, liye, KUCH, SKIP, kar, sakte, HO.

sort(), DOCUMENTS, ko, ORDER, karta hai — 1 (ASCENDING) YA, -1 (DESCENDING). limit(), RESULTS, ki, COUNT, RESTRICT, karta hai. skip(), FIRST, N, DOCUMENTS, ko, SKIP, karta hai — PAGINATION, ke, liye, USEFUL, hai.

sort() + limit() + skip() ko, CHAIN, kiya, ja, sakta hai — jaise, EK, "PAGE, 2" ki, PAGINATION, ke, liye, skip(10).limit(10) USE, hota hai.

// Newest, users, PEHLE (descending):
db.users.find().sort({ createdAt: -1 });

// Top 10 products, price, ke, hisaab se:
db.products.find().sort({ price: -1 }).limit(10);

// Pagination — page 2, 10, items, per, page:
db.products.find().sort({ price: -1 }).skip(10).limit(10);
📊
Sorting/limiting, EK, "TOP, 10, LIST" banaне, jaisa, hai — SAARE, ITEMS, ko, ORDER, mein, LAGAKE, (sort), SIRF, PEHLE, FEW, (limit) DIKHAТE, HO, aur, PAGINATION, ke, liye, KUCH, SKIP, kar, sakte, HO.
1 / 2
⚡ Quick Recap
  • sort() = 1 ascending, -1 descending
  • limit() = result count restrict, skip() = pagination ke liye N documents skip
  • Large datasets, ke, liye, skip(), slow, hai — cursor-based, pagination, BEHTAR, hai
Is page mein (2 subtopics)

Multiple, fields, PAR, sort, karne, ke, liye, EK, object, mein, MULTIPLE, keys, diye, ja, sakte, hain — priority, PEHLE, field, se, dhi, jaati, hai, TIE, hone, PAR, DUSRE, field, se, decide, hota, hai.

db.products.find().sort({ category: 1, price: -1 });
// pehle, category, alphabetically, phir, HAR, category, ke, andar, price, descending

Agar, sort, field, mein, DUPLICATE, values, HAIN, (jaise, MULTIPLE, products, ka, SAME, price), pagination, INCONSISTENT, ho, sakta, hai — HAMESHA, EK, UNIQUE, field, (jaise, _id) ko, TIE-BREAKER, ki, tarah, sort, mein, ADD, karo.

⚠️Common Mistake: Sirf, ek, non-unique, field, PAR, sort, karके, skip/limit, se, pagination, karne, PAR, SAME, item, DO, BAAR, dikh, sakta, hai, ya, MISS, ho, sakta, hai, agar, naye, documents, add/remove, hote, hain.