What is the MongoDB equivalent of the following SQL query [Choose all the apply]
SELECT * FROM kgroup 
WHERE age > 30 AND age < 70

db.kgroup.find ( 

{ age: { $gte: 30, $lte: 70 } } 

)

db.kgroup.find( 

{ $and: { age: { $gte: 30 } } ,{ age: { $lte: 70 } }  } 

)

db.kgroup.find( 

{ [$and: { age: { $gte: 30 } } ,{ age: { $lte: 70 } } ] } 

)

db.kgroup.find( 

{ age: { $gt: 30, $lt: 70 } } 

)

Verified Answer
Correct Option - d

To get all Infosys Certified Mongo Developer Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee

Telegram