SQL如何分组求助

[chinabdx]

select a.classcode,
a.classname,
SUM(b.actualmoney) as '2014销售',
COUNT(distinct b.flowno) as '2014客流',
SUM(b.actualmoney)/COUNT(distinct b.flowno) as '2014客单'
from inf_goodsclass a,
acc_goodsflow b
where a.classcode = LEFT(b.gdssalecode,4)
and a.classcode < '9000'
and b.saletime >= '2014-11-08 00:00'
and b.saletime <= '2014-11-09 23:59'
group by a.classcode,a.classname
order by a.classcode

如何把2015年的销售，客流，客单给直接查询到后面

[Yole]

您条件写的就是14年的，15年的只能在拼接一下了。

select a.classcode,
       a.classname,
       a.[2014销售],
       a.[2014客流],
       a.[2014客单],
       b.[2015销售],
       b.[2015客流],
       b.[2015客单]
       from
       (
select a.classcode,
       a.classname,
       SUM(b.actualmoney) as '2014销售',
       COUNT(distinct b.flowno) as '2014客流',
       SUM(b.actualmoney)/COUNT(distinct b.flowno) as '2014客单'
  from inf_goodsclass a,
       acc_goodsflow b
 where a.classcode = LEFT(b.gdssalecode,4)
   and a.classcode < '9000'
   and b.saletime >= '2014-11-08 00:00'
   and b.saletime <= '2014-11-09 23:59'
group by a.classcode,a.classname
) a
left join 
(
select a.classcode,
       a.classname,
       SUM(b.actualmoney) as '2015销售',
       COUNT(distinct b.flowno) as '2015客流',
       SUM(b.actualmoney)/COUNT(distinct b.flowno) as '2015客单'
  from inf_goodsclass a,
       acc_goodsflow b
 where a.classcode = LEFT(b.gdssalecode,4)
   and a.classcode < '9000'
   and b.saletime >= '2015-01-01 00:00'
   and b.saletime <= '2015-12-31 23:59'
group by a.classcode,a.classname
) b on a.classcode=b.classcode

[chinabdx]

谢谢了，还有没有其它的方法了

[chinabdx]

a.[2014销售], a.[2014客流], a.[2014客单], b.[2015销售], b.[2015客流], b.[2015客单] 客单用什么函数能让他四舍五入保留两位小数点

[迷糊丶]

ROUND(字段名,小数点后面位数）

[chinabdx]

这个客单里面保留两位数字后面的0能不能去掉

[道玄希言]

convert(decimal(18,2), ROUND(字段名, 2))

[chinabdx]

谢谢两位大神了