911

摘要： ---每日销售数量（不含运费）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... 阅读全文