1.查询所有记录
db.erpOrderGoods.find();
等价于SQL里的select * from erpOrderGoods;
2.去重查询
db.erpOrderGoods.distinct(“name”);
等价于SQL里的select distinct name from erpOrderGoods;
3.查询price=100的数据
db.erpOrderGoods.find({“price”:100});
4.查询price>100的数据
db.erpOrderGoods.find({price:{$gt:100}});
5.查询price<100的数据
db.erpOrderGood.find({price:{$lt:100}});
6.查询price>=100的数据
db.erpOrderGoods.find({price:{$gte:100}});
7.查询price<=100的数据
db.erpOrderGood.find({price:{$lte:100}});
8.查询price>100且price<200的数据
db.erpOrderGood.find({price:{$gte:100,$lte:200}});
9.查询name字段中包含”xhan”的数据
db.erpOrderGoods.find({name:/xhan/});
10.查询name字段中以”xhan”开头的数据
db.erpOrderGoods.find({name:/^xhan/});
11.查询指定列price、supplier的数据
db.erpOrderGoods.find({price:1,supplier:1});
12.查询指定列price、supplier,price>100的数据
db.erpOrderGoods.find({price:{$gt>100},{price:1,supplier:1});
13.按照销售价格高低进行排序
1)升序:db.erpOrderGoods.find.sord({price:1});
2)降序:db.erpOrderGoods.find.sord({price:-1});
14.查询price=100,supplier=star的数据
db.erpOrderGoods.find({price:100,supplier:’star’});
15.查询前5条数据
db.erpOrderGoods.find().limit(5);
16.查询第10条后的数据
db.erpOrderGoods.find().skip(10);
17.查询第5条到第10条之间的数据
db.erpOrderGoods.find().limit(5).skip(10);
18.or查询
db.erpOrderGoods.find({$or:[{price:100},{price:200}]});
19.查询某个结果集的记录数
db.erpOrderGoods.find({price:{$gte:100}}).count();
20.查询第一条数据
db.erpOrderGoods.findOne();
21.按照某列进行排序
db.erpOrders.find({operatorID: {$exists: true}}).count();