GroupBy的用法
Group By 是分组,当字段中有一样的记录时,用Group By 后,只会出现一条记录,这在做同类统计的时候特有效,
如:统计所有的大类销售,这时就必须用Group By
Select 酒水大类, Sum(价格) as [销售] From 点单表 Group By 酒水大类 Order By 销售
GroupBy的用法
Group By 是分组,当字段中有一样的记录时,用Group By 后,只会出现一条记录,这在做同类统计的时候特有效,
如:统计所有的大类销售,这时就必须用Group By
Select 酒水大类, Sum(价格) as [销售] From 点单表 Group By 酒水大类 Order By 销售
转载于:https://www.cnblogs.com/28088191/archive/2008/06/13/1219485.html