好好爱自己!

【理解】column must appear in the GROUP BY clause or be used in an aggregate function

column "ms.xxx_time" must appear in the GROUP BY clause or be used in an aggregate function

------------------------------------------------------------------------------------------

有min(), max(), sum(), avg()这些函数可以和group by 语句连在一起用。

The SQL GROUP BY statement is used along with the SQL aggregate functions like SUM to provide means of grouping the result dataset by certain database table column(s).

 

posted @ 2018-11-06 17:55  立志做一个好的程序员  阅读(18314)  评论(1编辑  收藏  举报

不断学习创作,与自己快乐相处