Using aggregate-free condition(s) in HAVING clause might be inefficient. Consider moving them to WHE
在使用Group By进行分组后,对分组后的数据进行Having过滤,DataGrip有时会出现如下错误Using aggregate-free condition(s) in HAVING clause might be inefficient. Consider moving them to WHERE例如查询语句如下:select s_id, round(avg(score.s_score),1) as avg_scorefrom scoregroup by score.s_idhavin
原创
2021-11-30 17:48:51 ·
1709 阅读 ·
0 评论