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语句如上,哪位大神指点一下。
Copyright 2014-2024 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!