select sum(进货数量),sum(进货价),sum(销售数量),sum(销售总价),sum(盈利) From table where datetime between 时间1 and 时间2
1楼的方法可以吧,如果你数据表结构中存储的就是这些值的话。sum函数不就解决了么
你的数据表结构是怎样的? select sum(进货数量),sum(进货数量)*进货单价,sum(销售数量),sum(销售数量)*销售单价,sum(销售数量)*(销售单价-进货单价) From table where 销售时间 between 时间1 and 时间2 group by 进货单价,销售单价
select sum(进货数量),sum(进货价),sum(销售数量),sum(销售总价),sum(盈利) From table where
datetime between 时间1 and 时间2
select sum(进货数量),sum(进货数量)*进货单价,sum(销售数量),sum(销售数量)*销售单价,sum(销售数量)*(销售单价-进货单价) From table where 销售时间 between 时间1 and 时间2 group by 进货单价,销售单价