mysql - 哪位大神能把这句sql用mongodb写出来啊？

Question

SELECT COUNT(DISTINCT(ccc)) AS ccc,COUNT(DISTINCT(bbb)) AS bbb FROM total WHERE user_id='$user_id' AND ADDDATE BETWEEN '$time[starttime]' AND '$endtime' GROUP BY aaa ORDER BY aaa DESC

sql语句如上，哪位大神指点一下。

Answer 1

考虑使用MongoDB的聚合：

1、COUNT(DISTINCT(ccc)) AS ccc,COUNT(DISTINCT(bbb)) AS bbb

$组+$总和

2、user_id='$user_id' 并在 '$time[starttime]' 和 '$endtime' 之间添加

$匹配

提供参考。

爱 MongoDB！玩得开心！