raghava20 / mongodb_task1 Goto Github PK

1.Find all the information about each products

db.collection.find({})

2.Find the product price which are between 400 to 800

db.collection.find({ product_price: { $gte: 400, $lte: 800 }})

3.Find the product price which are not between 400 to 600

db.collection.find({ product_price: { "$not": { $gte: 400, $lte: 800 } }})

4.List the four product which are grater than 500 in price

db.collection.find({"product_price": {"$gte": 500}}).limit(4)

5.Find the product name and product material of each products

db.collection.find({},{ product_name: 1, product_material: 1})

6.Find the product with a row id of 10

db.collection.find({id: "10"})

7.Find only the product name and product material

db.collection.find({},{ product_name: 1, product_material: 1})

8.Find all products which contain the value of soft in product material

db.collection.find({product_material: { "$eq": "Soft" }})

9.Find products which contain product color indigo and product price 492.00

db.collection.find({ "$or": [{product_color: "indigo" },{product_price: 492.00 }]})

10.Delete the products which product price value are same

db.collection.aggregate([ { "$group": { "_id": { product_price: "$product_price" }, total: { $sum: 1 } } }, { $match: { total: { $gt: 1 } } } ]).map(val=> db.collection.deleteMany({"product_price": val._id.product_price}))