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,min,max,server,sql,数量 From: https://www.cnblogs.com/lgx5/p/17799660.html