1
1357SELECT 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语句如上，哪位大神指点一下。
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
收藏
考虑使用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！