1、原始表
2、Compute 和 Compute By
select * from A where 数量>8 compute max(数量),min(数量),avg(数量)
执行结果如下:
select * from A where 数量>8 order by 类别 compute max(数量),min(数量),avg(数量) by 类别
- Compute server sql bycompute server sql by only_full_group_by incompatible sql_mode group only_full_group_by sql_mode mysql group only_full_group_by sql_mode版本 办法 x-powered-by powered知识server group only_full_group_by incompatible sql_mode only_full_group_by aggregated函数sql_mode only_full_group_by sql_mode解决方案 版本 server sql sql_server