![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
comesuh
这个作者很懒,什么都没留下…
展开
-
mysql 报错1055 GROUP BY 需要包含所有 在 SELECT 中出现的字段
[Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dps_test.qm_audit_plan_order.scheduled_end_time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=on转载 2020-06-11 14:30:16 · 772 阅读 · 0 评论 -
mysql统计某个字段不同值某个时间段数量之sum(case...when)
sum(case 属性名 when 属性值1 then 1 else 0 end),意思就是某个属性下为属性值1就加1个数量,否则就作0统计。原创 2020-06-11 14:27:38 · 1558 阅读 · 0 评论