Порядок
и порции

for doc in products.find({}, {"_id": 0, "title": 1, "price": 1}) \
                     .sort("price", -1) \
                     .limit(5):
    print(f'{doc["price"]:>7} {doc["title"]}')

mongocxx::options::find options;
options.projection(make_document(kvp("_id", 0), kvp("title", 1), kvp("price", 1)));
options.sort(make_document(kvp("price", -1)));
options.limit(5);

for (const auto& doc : products.find(make_document(), options)) {
    std::cout << doc["price"].get_int32().value << "  "
              << doc["title"].get_string().value << std::endl;
}

cursor, _ := products.Find(ctx, bson.D{},
    options.Find().
        SetProjection(bson.D{{Key: "_id", Value: 0},
            {Key: "title", Value: 1}, {Key: "price", Value: 1}}).
        SetSort(bson.D{{Key: "price", Value: -1}}).
        SetLimit(5))

var list []Product
cursor.All(ctx, &list)
for _, doc := range list {
    fmt.Printf("%8d  %s\n", doc.Price, doc.Title)
}

products.find({}, projection: { "_id" => 0, "title" => 1, "price" => 1 })
        .sort({ "price" => -1 })
        .limit(5)
        .each { |doc| puts format("%8d  %s", doc["price"], doc["title"]) }

page, per_page = 2, 5

for doc in products.find({}, {"_id": 0, "title": 1}) \
                     .sort("title", 1) \
                     .skip((page - 1) * per_page) \
                     .limit(per_page):
    print(doc["title"])

int page = 2, per_page = 5;

mongocxx::options::find options;
options.projection(make_document(kvp("_id", 0), kvp("title", 1)));
options.sort(make_document(kvp("title", 1)));
options.skip((page - 1) * per_page);
options.limit(per_page);

for (const auto& doc : products.find(make_document(), options))
    std::cout << doc["title"].get_string().value << std::endl;

page, perPage := int64(2), int64(5)

cursor, _ := products.Find(ctx, bson.D{},
    options.Find().
        SetProjection(bson.D{{Key: "_id", Value: 0}, {Key: "title", Value: 1}}).
        SetSort(bson.D{{Key: "title", Value: 1}}).
        SetSkip((page - 1) * perPage).
        SetLimit(perPage))

var rows []bson.M
cursor.All(ctx, &rows)
for _, doc := range rows {
    fmt.Println(doc["title"])
}

page, per_page = 2, 5

products.find({}, projection: { "_id" => 0, "title" => 1 })
        .sort({ "title" => 1 })
        .skip((page - 1) * per_page)
        .limit(per_page)
        .each { |doc| puts doc["title"] }

col.find({}, {"_id": 1}) \
   .sort("_id", 1) \
   .skip(19990).limit(10)

mongocxx::options::find options;
options.sort(make_document(kvp("_id", 1)));
options.skip(19990);
options.limit(10);

col.find(make_document(), options);

col.Find(ctx, bson.D{},
    options.Find().
        SetSort(bson.D{{Key: "_id", Value: 1}}).
        SetSkip(19990).SetLimit(10))

col.find({}, projection: { "_id" => 1 })
   .sort({ "_id" => 1 })
   .skip(19990).limit(10)

col.find({"_id": {"$gt": last_seen_id}}, {"_id": 1}) \
   .sort("_id", 1) \
   .limit(10)

mongocxx::options::find options;
options.sort(make_document(kvp("_id", 1)));
options.limit(10);

col.find(make_document(kvp("_id",
        make_document(kvp("$gt", last_seen_id)))), options);

col.Find(ctx,
    bson.D{{Key: "_id", Value: bson.D{{Key: "$gt", Value: lastSeenID}}}},
    options.Find().
        SetSort(bson.D{{Key: "_id", Value: 1}}).SetLimit(10))

col.find({ "_id" => { "$gt" => last_seen_id } }, projection: { "_id" => 1 })
   .sort({ "_id" => 1 })
   .limit(10)

print("всего товаров:", products.count_documents({}))
print("ноутбуков:", products.count_documents({"category": "ноутбуки"}))
print("заказов:", orders.count_documents({}))
print("доставленных:", orders.count_documents({"status": "доставлен"}))

std::cout << "всего товаров: " << products.count_documents(make_document()) << std::endl;
std::cout << "ноутбуков: " << products.count_documents(
    make_document(kvp("category", "ноутбуки"))) << std::endl;
std::cout << "заказов: " << orders.count_documents(make_document()) << std::endl;
std::cout << "доставленных: " << orders.count_documents(
    make_document(kvp("status", "доставлен"))) << std::endl;

n, _ := products.CountDocuments(ctx, bson.D{})
fmt.Println("всего товаров:", n)

n, _ = products.CountDocuments(ctx,
    bson.D{{Key: "category", Value: "ноутбуки"}})
fmt.Println("ноутбуков:", n)

n, _ = orders.CountDocuments(ctx, bson.D{})
fmt.Println("заказов:", n)

n, _ = orders.CountDocuments(ctx,
    bson.D{{Key: "status", Value: "доставлен"}})
fmt.Println("доставленных:", n)

puts "всего товаров: #{products.count_documents({})}"
puts "ноутбуков: #{products.count_documents({ 'category' => 'ноутбуки' })}"
puts "заказов: #{orders.count_documents({})}"
puts "доставленных: #{orders.count_documents({ 'status' => 'доставлен' })}"