昨天刚刚独立完成了一次月销售增长分析报表,发现了很多问题和方法,觉得很有必要来记录一下.
首先贴一下代码:
/*dialect*/
select Fnumber,FName_l2,sum(NowFQty) NowFQty,sum(LastFQty) LastFQty,sum(NowFAmount) NowFAmount,sum(LastFAmount) LastFAmount,sum(NowFPrice) NowFPrice,sum(LastFPrice) LastFPrice -