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 DESCsql語句如上，哪位大神指點(diǎn)一下。
1
0
0
考慮使用MongoDB的聚合：
1、COUNT(DISTINCT(ccc)) AS ccc,COUNT(DISTINCT(bbb)) AS bbb
$組+$總和
2、user_id='$user_id' 並在 '$time[starttime]' 和 '$endtime' 之間加入
$匹配
提供參考。
愛 MongoDB！玩得開心！
