2010年2月22日
销售统计SQL
摘要： ---每日销售数量（不含运费）select a.date as '日期',sum(a.je) as '销售额' from (select (productnum*paid) as je,convert(varchar(100),orders.act_time5,23) as date from orders where state=5 and act_time5>='2010-02-12 0... 阅读全文
posted @ 2010-02-22 10:02 911 阅读(506) 评论(0) 推荐(0) 编辑