编写查询时如何计算值 [英] how to calculate value while writing query
问题描述
使用以下查询,我得到以下数据
从条目WHERE中选择项目,收入,日期,数量,金额("2012-03-24"和"2012-03-25"之间的日期)
项目数量收入金额日期
item1 10 10 100 2012-03-24
item2 10 10 100 2012-03-24
item3 10 10 100 2012-03-24
item4 10 10 100 2012-03-25
item1 10 10 100 2012-03-25
item2 10 10 100 2012-03-25
item3 10 10 100 2012-03-25
item4 10 10 100 2012-03-25
但是我想像下面这样.
有人可以建议我通过这种方式获取数据的SQL查询是什么吗?
项目数量收入金额
item1 20 10 200
item2 20 10 200
item3 20 10 200
item4 20 10 200
using this following query i am getting this below data
SELECT item,revenue,date,qty,amount FROM entry WHERE (date BETWEEN ''2012-03-24'' AND ''2012-03-25'')
ITEM QTY REVENUE AMOUNT DATE
item1 10 10 100 2012-03-24
item2 10 10 100 2012-03-24
item3 10 10 100 2012-03-24
item4 10 10 100 2012-03-25
item1 10 10 100 2012-03-25
item2 10 10 100 2012-03-25
item3 10 10 100 2012-03-25
item4 10 10 100 2012-03-25
But i want to get like the following way.
Can anyone suggets me what''s the SQL query to get data this way?
ITEM QTY REVENUE AMOUNT
item1 20 10 200
item2 20 10 200
item3 20 10 200
item4 20 10 200
推荐答案
试试这个查询..
Hi,
Try this query..
SELECT item, SUM(revenue), SUM(qty), SUM(amount) FROM entry WHERE (date BETWEEN '2012-03-24' AND '2012-03-25') GROUP BY item
希望它能起作用
Hope it works
这篇关于编写查询时如何计算值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!