1.SELECT MONTH(SellTime) as selltime,SUM(TotalPrice) as total FROM Sell WHERE YEAR(SellTime)=CONVERT(varchar(4),getdate(),120) GROUP BY MONTH(SellTime)
1）SellTime销售时间
2）TotalPrice销售金额
posted on 2014-02-26 11:27 晴.天 阅读(680) 评论(0) 编辑 收藏 举报
