首页 > 移动平台 > 详细

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

时间:2018-11-06 18:05:49      阅读:1712      评论:0      收藏:0      [点我收藏+]

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).

 

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

原文:https://www.cnblogs.com/oxspirt/p/9916827.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!