:Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column

<p>解决方法就是Sql order by 和 group BY一起使用时需要注意,.ORDER BY 排序字段必须包含在聚合函数或 GROUP BY 子句中</p><p>其中聚合函数是：avg count max min sum</p>