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 DESC
LIMIT 10
...
原创
2019-02-20 17:25:04 ·
1021 阅读 ·
0 评论