Column '###' is invalid in the select list because it is not contained in either an aggregate ......

数据库报错：Column 'temTable.customStatus' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

原因：group by 后面是要跟着的 select 中所有不是聚合函数的字段。

解决：把该字段放在group by 后面即可。