查找个人最好成绩科目; { name: '张三', score: [{subject: '语文', score: 84}, {subject: '数学', score: 90}, {subject: '外语', score: 69}]
} db.students.aggregate([{$unwind: 'score'}]) {name: '张三', score: {subject: '语文', score: 84}} {name: '张三', score: {subject: '数学', score: 90}} {name: '张三', score: {subject: '外语', score: 69}} db.students.aggregate([ {$unwind: '$score'}, {$sort: {name:1, "score.score": -1}} ]} {name: '张三', score: {subject: '数学', score: 90}} {name: '张三', score: {subject: '语文', score: 84}} {name: '张三', score: {subject: '外语', score: 69}}
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。