Tom-Net

导航

按年月份统计总金额

select year(Add_Date) as 年, month(Add_Date) as 月份 ,Sum(Price) as 总金额 from Product group by year(Add_Date) ,month(Add_Date) order by month(Add_Date) asc

posted on 2009-05-27 19:44  Tom_Net  阅读(115)  评论(0)    收藏  举报