java mongodb分组查询及与mysql语法比较
举例:查询表user_info的所有机构id, 机构对应人数,用户的最大年龄mysql语法:SELECT orgId, count(1) as orgId_total, max(age) as age_max FROM user_info GROUP BY orgId HAVING age_max>=40 ORDER BY orgId_total DESCLIMIT 10...
原创
2019-02-20 17:25:04 ·
1080 阅读 ·
0 评论