1.with cube 用法 统计出全部的信息select tem,Color,sum(people) as QtySum from auth group by tem,Color with cubetem Color QtySum -------------------- -------------------- ---------Chair Blue 101.00 Chair Red 210.00 Chair (null) 311.00 Table Blue 124.00 Table Red 223.00 Table (null) 347.00 ( Read More