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

问题描述

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语句如上，哪位大神指点一下。

问题解答

考虑使用MongoDB的aggregation：

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

$group+$sum

2、user_id=’$user_id’ AND ADDDATE BETWEEN ’$time[starttime]’ AND ’$endtime’

$match

供参考。

Love MongoDB！Have fun！