Một nhóm khóa thường là một trường hoặc nhóm các trường. The key group can be result of a expression. Use field
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 trong đoạn đường ốngdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 để đặt khóa nhóm. Xem dưới đây để biết ví dụ sử dụng. ví dụ sử dụngIn the first stage
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4, fielddb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 was set to the group key for that documentTài liệu đầu ra cũng có thể chứa các trường bổ sung được đặt bằng cách sử dụng các biểu thức tích lũy. biểu thức tích lũy.
Ghi chú
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 không đặt hàng tài liệu đầu ra của nó. không đặt hàng tài liệu đầu ra của nógiai đoạn
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 has a nguyên mẫu sau. Giai đoạn db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4sân khấu có dạng nguyên mẫu sau. db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
0đồng ruộng
Mô tả sự kiện
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6Request. Biểu thức
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 only key group. Nếu bạn chỉ định giá trịdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 của NULL hoặc bất kỳ giá trị hằng số nào khác, giai đoạndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 sẽ trả về một tài liệu duy nhất tổng hợp các giá trị trên tất cả các tài liệu đầu vào. Xem nhóm bằng ví dụ NULL. Xem ví dụ Nhóm theo Nulldb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
56Không bắt buộc. Tính toán bằng cách sử dụng các thuật toán tích lũy. toán tử tích lũy.
Các toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 và bộ tích lũy có thể chấp nhận bất kỳ db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
58 hợp lệ nào. To know more information about the expression, view expression. toán tử tích lũycó thể chấp nhận bất kỳ ______058 hợp lệ. Để biết thêm thông tin về các biểu thức, hãy xem Biểu thứcToán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
59 phải là một trong các khoản tích lũy sau thanh toánChanged in version 5. 0
Mười
Mô tả sự kiện
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
00Request. Biểu thức
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 only key group. Nếu bạn chỉ định giá trịdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 của NULL hoặc bất kỳ giá trị hằng số nào khác, giai đoạndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 sẽ trả về một tài liệu duy nhất tổng hợp các giá trị trên tất cả các tài liệu đầu vào. Xem nhóm bằng ví dụ NULLdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
01Không bắt buộc. Tính toán bằng cách sử dụng các thuật toán tích lũy
Các toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 và tích lũy tích lũy có thể chấp nhận bất kỳ hợp lệ nàodb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
58. To know more information about the expression, view expressiondb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
03Toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
59 phải là một trong các khoản tích lũy sau thanh toánCác toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 và tích lũy tích lũy có thể chấp nhận bất kỳ hợp lệ nàodb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
58. To know more information about the expression, view expressiondb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
05Toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
59 phải là một trong các khoản tích lũy sau thanh toánChanged in version 5. 0
Mười
Giai đoạndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 vàdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
02db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
08Trả về kết quả của chức năng tích lũy do người dùng xác định
Changed in version 5. 0
Mười
Giai đoạndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 vàdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
02db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
82Trả về kết quả của chức năng tích lũy do người dùng xác định
Trả về một mảng các giá trị biểu thức duy nhất cho mỗi nhóm. Thứ tự của các phần tử mảng không được xác định
Changed in version 5. 0. Có sẵn trong giai đoạn
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
02db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
86Trả về trung bình của các giá trị số. Bỏ qua các giá trị không phải là số
Trả về các phần tử bên dưới trong một nhóm theo thứ tự sắp xếp được chỉ định
Các toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 và tích lũy tích lũy có thể chấp nhận bất kỳ hợp lệ nàodb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
58. To know more information about the expression, view expressiondb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
89Toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
59 phải là một trong các khoản tích lũy sau thanh toánChanged in version 5. 0
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
54Mười
Trả về kết quả của chức năng tích lũy do người dùng xác định
Các toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 và tích lũy tích lũy có thể chấp nhận bất kỳ hợp lệ nàodb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
58. To know more information about the expression, view expressiondb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
57Toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
59 phải là một trong các khoản tích lũy sau thanh toánChanged in version 5. 0
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
02Mười
Các toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 và tích lũy tích lũy có thể chấp nhận bất kỳ hợp lệ nàodb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
58. To know more information about the expression, view expressiondb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
04Toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
59 phải là một trong các khoản tích lũy sau thanh toánChanged in version 5. 0
Mười
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4,db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
02 và như một biểu thứcdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
09Trả về kết quả của chức năng tích lũy do người dùng xác định
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
80Trả về một mảng các giá trị biểu thức duy nhất cho mỗi nhóm. Thứ tự của các phần tử mảng không được xác định
Các toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 và tích lũy tích lũy có thể chấp nhận bất kỳ hợp lệ nàodb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
58. To know more information about the expression, view expressiondb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
82Toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
59 phải là một trong các khoản tích lũy sau thanh toánCác toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 và tích lũy tích lũy có thể chấp nhận bất kỳ hợp lệ nàodb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
58. To know more information about the expression, view expressiondb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
84Toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
59 phải là một trong các khoản tích lũy sau thanh toánCác toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 và tích lũy tích lũy có thể chấp nhận bất kỳ hợp lệ nàodb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
58. To know more information about the expression, view expressiondb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
86Toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
59 phải là một trong các khoản tích lũy sau thanh toánCác toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 và tích lũy tích lũy có thể chấp nhận bất kỳ hợp lệ nàodb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
58. To know more information about the expression, view expressiondb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
88Toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
59 phải là một trong các khoản tích lũy sau thanh toánCác toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 và tích lũy tích lũy có thể chấp nhận bất kỳ hợp lệ nàodb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
58. To know more information about the expression, view expressiondb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
70Toán tử
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
59 phải là một trong các khoản tích lũy sau thanh toánChanged in version 5. 0
Mười
Giai đoạndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 vàdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
02db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
73Trả về kết quả của chức năng tích lũy do người dùng xác định
Changed in version 5. 0
Mười
Giai đoạndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 vàdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
02Trả về kết quả của chức năng tích lũy do người dùng xác định
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 giai đoạn có giới hạn 100 megabyte RAM. Theo mặc định, nếu giai đoạn vượt quá giới hạn này, db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 sẽ trả về lỗi. Để có thêm không gian cho quá trình xử lý giai đoạn, hãy sử dụng tùy chọn allowDiskUse để kích hoạt các giai đoạn đường ống tổng hợp để ghi dữ liệu vào các tệp tạm thời. mẹo
Xem thêm
Phần mô tả tối ưu hóa này để cải thiện hiệu quả của
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4. Có những tối ưu hóa mà bạn có thể thực hiện thủ công và tối ưu hóa MongoDB làm cho nội bộ. ______04 . Có những tối ưu hóa mà bạn có thể thực hiện thủ công và tối ưu hóa MongoDB thực hiện nội bộ. If a pipe
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
800 và_______0801 theo cùng một trường và giai đoạndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 chỉ sử dụng toán tửdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
86, vui lòng xem xét thêm một mục trên trường được nhóm phù hợp với thứ tự sắp xếp. Trong một số trường hợp, giai đoạndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 có thể sử dụng chỉ mục để nhanh chóng tìm kiếm tài liệu đầu tiên của mỗi nhóm. ______0801 theo cùng một trường và giai đoạn db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 chỉ sử dụng toán tử tích lũydb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
86 . Trong một số trường hợp, giai đoạn ______04 có thể sử dụng chỉ mục để tìm nhanh tài liệu đầu tiên của mỗi nhóm. Thí dụ
If a collection filename
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
805 có chứa một chỉ mụcdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
806, đường ống sau đó có thể sử dụng chỉ mục đó để tìm tài liệu đầu tiên của mỗi nhóm. db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
8Start from version 5. 2, MongoDB sử dụng công cụ truy vấn thực thi dựa trên khe để thực thi các giai đoạn
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 if one in two. ______04 giai đoạn nếu một trong hai.
4 là giai đoạn đầu tiên trong đường ốngdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
Tất cả các giai đoạn trước trong đường ống cũng có thể được thực hiện nhờ động cơ dựa trên khe
Để biết thêm thông tin, xem tối ưu hóa
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4trọng
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
810, hãy tạo một bộ sưu tập mẫu có têndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
811 với các tài liệu sau. ______0810 , tạo bộ sưu tập mẫu có têndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
811 với các tài liệu sau. db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
Tổng hợp hoạt động sau đây sử dụng giai đoạn
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 to đếm số lượng tài liệu trong bộ sưu tậpdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
811. Giai đoạn ______04 để đếm số tài liệu trong bộ sưu tập____0811. db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
5Operations return to results
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
0Tổng hợp hoạt động này tương thích với câu lệnh SQL sau
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
8mẹo
Tổng hợp hoạt động sau đây sử dụng giai đoạn
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 để truy xuất các giá trị mục riêng biệt từ bộ sưu tậpdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
811. Giai đoạn ______04 để truy xuất các giá trị mục riêng biệt từ bộ sưu tậpdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
811. db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
5Operations return to results
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
0Tổng hợp hoạt động này tương thích với câu lệnh SQL sau
________ 08 Hoạt động tổng hợp sau đây sử dụng giai đoạndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 để truy xuất các giá trị mục riêng biệt từ bộ sưu tậpdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
811. ______04 nhóm giai đoạn các tài liệu theodb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
816 để truy xuất các giá trị mục riêng biệt. Giai đoạn này trả vềdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
819 cho mỗi mục. Giai đoạn thứ hai. Giai đoạn ____0820 lọc các tài liệu kết quả để chỉ trả về các mục có adb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
819 lớn hơn hoặc bằng 100. Operations return to results
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
7Tổng hợp hoạt động này tương thích với câu lệnh SQL sau
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
80mẹo
Xem thêm
trọng
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
810, hãy tạo một bộ sưu tập mẫu có têndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
811 với các tài liệu sau. ______0810 , tạo bộ sưu tập mẫu có têndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
811 với các tài liệu sau. db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
Tổng hợp hoạt động sau đây sử dụng giai đoạn
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 to đếm số lượng tài liệu trong bộ sưu tậpdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
811. db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
82Activity return results after. ______04 phân nhóm các tài liệu theo ngày và tính tổng số lượng bán, số lượng trung bình và tổng số tài liệu trong mỗi nhóm. Giai đoạn thứ ba. Giai đoạn ____0826 sắp xếp kết quả theo tổng số tiền bán cho mỗi nhóm theo thứ tự giảm dần. Tổng hợp hoạt động này tương thích với câu lệnh SQL sau
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
83Tổng hợp hoạt động này tương thích với câu lệnh SQL sau
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
84Tổng hợp hoạt động sau đây sử dụng giai đoạn
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 để truy xuất các giá trị mục riêng biệt từ bộ sưu tậpdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
811. db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
85Operations return to results
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
86Tổng hợp hoạt động này tương thích với câu lệnh SQL sau
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
87Tổng hợp hoạt động sau đây sử dụng giai đoạn
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 để truy xuất các giá trị mục riêng biệt từ bộ sưu tậpdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
811. ______0810 , tạo bộ sưu tập mẫu có têndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
830 với các tài liệu sau. db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
88Tài liệu của các nhóm hoạt động tổng hợp sau đây theo trường
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
816, tính toán tổng số tiền bán cho mỗi mặt hàng và chỉ trả lại những mặt hàng có tổng số tiền bán hơn hoặc bằng 100. db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
89Giai đoạn đầu tiên. giai đoạn
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 nhóm tài liệu bằng ____0816 để truy xuất các giá trị vật chất riêng biệt. Giai đoạn này được trả về____0819 cho mỗi mục. Giai đoạn thứ hai. Giai đoạndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
820 lọc các tài liệu kết quả để chỉ trả về các mục vớidb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
819 lớn hơn hoặc bằng 100. db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
0Đường ống sau đây tính toán tổng số tiền bán hàng, số lượng bán hàng trung bình và số lượng bán hàng cho từng ngày trong năm 2014
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
1Giai đoạn đầu tiên. Giai đoạndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
820 lọc tài liệu chỉ chuyển các tài liệu từ năm 2014 sang giai đoạn tiếp theo. Giai đoạn thứ hai. Giai đoạn ____24 nhóm tài liệu theo ngày và tính toán tổng lượng bán, lượng trung bình và tổng số tài liệu trong các tài liệu trong mỗi nhóm. Giai đoạn thứ hai. Giai đoạndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
826 sắp xếp kết quả theo tổng số tiền bán cho mỗi nhóm theo thứ tự giảm dầnActivation return results after. sử dụng
Biến hệ thốngdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
834 để nhóm toàn bộ tài liệu theo tác giả. Giai đoạn này chuyển các tài liệu sau sang giai đoạn tiếp theo. db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
2Hoạt động tổng hợp sau đây chỉ định một nhómdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
6 củadb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
828, tính toán tổng lượng bán, lượng trung bình và lượng của tất cả các tài liệu trong bộ sưu tậptrọng
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
810, hãy tạo một bộ sưu tập mẫu có têndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
830 với các tài liệu sauTổng hợp hoạt động sau đây xoay vòng dữ liệu trong bộ sưu tập db. foo. tổng hợp[[ { $sắp xếp. {x. 1, y. 1 } }, { nhóm $. { _Tôi. {x. "$x" }, y. { $first. "$y" } } }]]30 để có các tiêu đề được nhóm bởi các tác giả
Giai đoạn đầu tiên. giai đoạn
db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 nhóm tài liệu bằng ____0816 để truy xuất các giá trị vật chất riêng biệt. Giai đoạn này được trả về____0819 cho mỗi mục. Giai đoạn thứ hai. Giai đoạndb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
820 lọc các tài liệu kết quả để chỉ trả về các mục vớidb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
819 lớn hơn hoặc bằng 100. db.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
3mẹo
Xem thêm
Đường ống sau đây tính toán tổng số tiền bán hàng, số lượng bán hàng trung bình và số lượng bán hàng cho từng ngày trong năm 2014
Toán tửdb.sales.insertMany[[ { "_id" : 1, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["2"], "date" : ISODate["2014-03-01T08:00:00Z"] }, { "_id" : 2, "item" : "jkl", "price" : NumberDecimal["20"], "quantity" : NumberInt["1"], "date" : ISODate["2014-03-01T09:00:00Z"] }, { "_id" : 3, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt[ "10"], "date" : ISODate["2014-03-15T09:00:00Z"] }, { "_id" : 4, "item" : "xyz", "price" : NumberDecimal["5"], "quantity" : NumberInt["20"] , "date" : ISODate["2014-04-04T11:21:39.736Z"] }, { "_id" : 5, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["10"] , "date" : ISODate["2014-04-04T21:23:13.331Z"] }, { "_id" : 6, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["5" ] , "date" : ISODate["2015-06-04T05:08:13Z"] }, { "_id" : 7, "item" : "def", "price" : NumberDecimal["7.5"], "quantity": NumberInt["10"] , "date" : ISODate["2015-09-10T08:43:00Z"] }, { "_id" : 8, "item" : "abc", "price" : NumberDecimal["10"], "quantity" : NumberInt["5" ] , "date" : ISODate["2016-02-06T20:20:13Z"] },]]
4 trong trường hợp sử dụng phổ biếnTập hợp nhóm là gì?
Một tổng hợp là một tập hợp những người tình cờ ở cùng một nơi cùng một lúc nhưng không có mối liên hệ nào khác với nhau. Ví dụ. Những người tập trung trong một nhà hàng vào một buổi tối cụ thể có thể là một ví dụ về tổng hợp, không phải là một nhóm. tập hợp những người tình cờ ở cùng một địa điểm vào cùng một thời điểm nhưng không có mối liên hệ nào khác với nhau . Ví dụ. Những người tụ tập tại một nhà hàng vào một buổi tối cụ thể là một ví dụ về tập hợp, không phải nhóm.
Tổng hợp trong MongoDB đưa ra ví dụ là gì?
Một đường ống tổng hợp bao gồm một hoặc nhiều giai đoạn xử lý các tài liệu. Mỗi giai đoạn thực hiện một thao tác trên các tài liệu đầu vào. Ví dụ, một giai đoạn có thể lọc các tài liệu, nhóm tài liệu và tính toán các giá trị. Các tài liệu được bắt đầu từ một giai đoạn được chuyển sang giai đoạn tiếp theo. Mỗi giai đoạn thực hiện một thao tác trên chứng từ đầu vào . Ví dụ: một giai đoạn có thể lọc tài liệu, nhóm tài liệu và tính toán giá trị. Các tài liệu được xuất ra từ một giai đoạn được chuyển sang giai đoạn tiếp theo.
Các chức năng tổng hợp trong MongoDB là gì?
Trong MongoDB, các hoạt động tổng hợp xử lý các bản ghi/tài liệu dữ liệu và trả về kết quả được tính toán. Nó thu thập các giá trị từ các tài liệu khác nhau và nhóm chúng lại với nhau và sau đó thực hiện các loại hoạt động khác nhau trên dữ liệu được nhóm đó như tổng, trung bình, tối thiểu, tối đa, v. v. to return to results used to tính toán. xử lý bản ghi dữ liệu/tài liệu và trả về kết quả đã tính . Nó thu thập các giá trị từ các tài liệu khác nhau và nhóm chúng lại với nhau, sau đó thực hiện các loại hoạt động khác nhau trên dữ liệu được nhóm đó như tổng, trung bình, tối thiểu, tối đa, v.v. để trả về kết quả được tính toán.
Chúng ta có thể làm nhóm trong MongoDB không?
Chúng tôi có thể nhóm theo đơn cũng như nhiều trường từ bộ sưu tập, chúng tôi có thể sử dụng nhà điều hành nhóm $ trong MongoDB để nhóm từ bộ sưu tập và trả về tài liệu mới. Chúng tôi đang sử dụng $AVG, $Sum, $Max, $Min, $Push, $uối cùng, $đầu tiên và $addtoset Toán tử với nhóm trong MongoDB