MongoDB常用查询（对比SQL）

MongoDB:

show dbs

show collections

db.getCollection('bills').find({})

db.getCollection('bills').find({}).limit(5)

db.getCollection('users').find({}, {"user_details.email": 1} )

db.getCollection('bills').find({"owner_details.email": "test03@energo.cn", "status": 1}).sort({"owner_details.email": 1})

db.getCollection('bills').find({ $or: [{"owner_details.email": "test03@energo.cn"}, {"owner_details.email": "test06@energo.cn"} ]}).sort({"owner_details.email": -1})

db.getCollection('bills').find({total_energy_produced:{$ne: 0}, $or: [{"owner_details.email": "test03@energo.cn"}, {"owner_details.email": "test06@energo.cn"} ]}).sort({"owner_details.email": -1})

db.bills.find({total_energy_produced:{$ne: 0} })

db.bills.aggregate([
{$match : {period_from: {"$gte" : ISODate("2018-01-31T01:50:00.000Z"), "$lt" : ISODate("2018-02-28T02:38:00.000Z") }}},
{$group : {_id: "$owner", consumed_total_amount : {$sum : "$total_energy_consumed"}}},
{$sort: {"consumed_total_amount": -1}}
])

db.bills.aggregate([
{$match : {total_energy_produced:{$ne: 0}, period_from: {"$gte" : ISODate("2018-01-31T01:50:00.000Z"), "$lt" : ISODate("2018-02-28T02:38:00.000Z") }}},
{$group : {_id: "$owner", consumed_total_amount : {$sum : "$total_energy_consumed"}}},
{$sort: {"consumed_total_amount": -1}}
])

db.getCollection('bills').find({"owner_details.email": "test06@energo.cn", "period_from" : {"$gte" : ISODate("2017-12-22T04:59:00.000Z"), "$lt" : ISODate("2017-12-22T05:59:00.000Z") } }, {owner: 1, total_clean_energy_bought:1,placed_auction:1})