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！玩得開心！