使用sql语句统计每个区域的销售额

‘壹’ sql怎么统计各类销售利润

select number,(sum(sell_price) - count(sell_price) * (select in_price from phone where number = s.number)) as profit from sales as s group by number;
利润计算规则：
按手机型号计算累计销售额sum(sell_price)
-
按手机型号计算累计销售量count(sell_price) * 进货价 (select in_price from phone where number = s.number)
= 销售利润

‘贰’ 如何用SQL语句统计总金额和区段金额

select合同ID,SUM(收费金额)as总金额,(selectsum(收费金额)from收费whereDATEPART(yy,收费时间)=2013anda.合同ID=收费.合同ID)as年度金额

from收费asagroupby合同ID

‘叁’ sql如何按地区统计销售额

时间是什么格式？如果是datetime的话，数据库是mysql还是sqlserver？

sqlserver的话：

selecttop5region,sum(totalprice)from[order]whereyear(requireddate)=xxxxorderbysum(totalprice)desc

mysql的话：

selectregion,sum(totalprice)from[order]whereyear(requireddate)=xxxxorderbysum(totalprice)desclimit5

‘肆’ 请问 sqlserver 各个商品各月销售额统计 sql语句怎么写

可以完成,思路如下:

通过pid 商品编码分组,得到销售日期的每个月列,后用sum(caseFact_mWHEN月份 then数量end)来操作即可.

--年度售额：
selectpid商品编码
,isnull(convert(dec(18,2),sum(caseFact_mWHEN'01'thencCostend)),0)'countCost_1'
,isnull(convert(dec(18,2),sum(caseFact_mWHEN'02'thencCostend)),0)'countCost_2'
,isnull(convert(dec(18,2),sum(caseFact_mWHEN'03'thencCostend)),0)'countCost_3'
,isnull(convert(dec(18,2),sum(caseFact_mWHEN'04'thencCostend)),0)'countCost_4'
,isnull(convert(dec(18,2),sum(caseFact_mWHEN'05'thencCostend)),0)'countCost_5'
,isnull(convert(dec(18,2),sum(caseFact_mWHEN'06'thencCostend)),0)'countCost_6'
,isnull(convert(dec(18,2),sum(caseFact_mWHEN'07'thencCostend)),0)'countCost_7'
,isnull(convert(dec(18,2),sum(caseFact_mWHEN'08'thencCostend)),0)'countCost_8'
,isnull(convert(dec(18,2),sum(caseFact_mWHEN'09'thencCostend)),0)'countCost_9'
,isnull(convert(dec(18,2),sum(caseFact_mWHEN'10'thencCostend)),0)'countCost_10'
,isnull(convert(dec(18,2),sum(caseFact_mWHEN'11'thencCostend)),0)'countCost_11'
,isnull(convert(dec(18,2),sum(caseFact_mWHEN'12'thencCostend)),0)'countCost_12'
,isnull(convert(dec(18,2),sum(cCost)))'countTotal'
fromTabgroupbypid
--Fact_m指的就是销售日期[月],最后还有一列为年度总计

希望能帮到你！

‘伍’ 如何用sql统计总金额

1、如果你是要统计当日销售总金额，如下：
select
sum(piece*price)
as
'当日销售总额'
from
当日销售表
where
date='07/5/16'
2、如果你是要统计各商品当日的销售额，如下：
select
rq,sno,sname,sum(piece)
as
piece,sum(piece*price)
as
'销售额'
from
当日销售表
group
by
rq,sno,sname

‘陆’ 如何用sql语句统计出一个部门的总销售额

select dept,sum(mny) mny from sale
group by dept

‘柒’ sql 查询问题（根据名称去统计销售金额）

select销售ID,销售人,销售时间=max(销售时间),销售金额=sum(销售金额)from销售表
GROUPBY销售ID,销售人

‘捌’ SQL如何统计某段时间某业务员销售总额、指定商品销售额及该商品占比

select 业务员,销售总量,A产品销售数量,(A产品销售数量/销售总量,) as A产品占比 from (select 业务员，sum(销售数量) as 销售总量,(select sum(销售数量) from tablename where a.业务员=业务员 and 产品='A' group by 业务员) as A产品销售数量 from tablename a where 业务员='张三' group by 业务员) a

‘玖’ SQL如何统计某段时间某业务员销售总额、指定商品销售额及该商品占比

select
业务员,销售总量,A产品销售数量,(A产品销售数量/销售总量,)
as
A产品占比
from
(select
业务员，sum(销售数量)
as
销售总量,(select
sum(销售数量)
from
tablename
where
a.业务员=业务员
and
产品='A'
group
by
业务员)
as
A产品销售数量
from
tablename
a
where
业务员='张三'
group
by
业务员)
a