SELECT uid FROM(SELECT uid,`date`,sum(score) AS total_score FROM scores WHERE `date` > '2017-03-01' AND `date` < '2017-03-31' GROUP BY uid,`date` HAVING total_score > 2 ORDER BY uid,date) u GROUP BY uid HAVING count(*) > 15;
mysql having的运用
最新推荐文章于 2023-05-21 21:05:48 发布