㈠ 求一句按月汇总销售额的sql语句
select substr(to_char(订单日期,'yyyymmdd'),0,6),sum(销售额) from 表 group by substr(to_char(订单日期,'yyyymmdd'),0,6);
㈡ sql 查询问题（根据销售人去统计销售金额）
SELECT 销售ID，销售人， 销售时间，SUM( 销售金额) FROM 销售表 GROUP BY 销售人
㈢ sql--按照季度统计销售额 怎么写
俩方法
selectyear(订单.订购日期)年份,
sum(casewhenmonth(订单.订购日期)between1and3then订单明细.单价*订单明细.数量else0end)一季度销售金额,
sum(casewhenmonth(订单.订购日期)between4and6then订单明细.单价*订单明细.数量else0end)二季度销售金额,
sum(casewhenmonth(订单.订购日期)between7and9then订单明细.单价*订单明细.数量else0end)三季度销售金额,
sum(casewhenmonth(订单.订购日期)between10and12then订单明细.单价*订单明细.数量else0end)四季度销售金额
from订单,订单明细
where订单.订单ID=订单明细.订单IDandyear(订单.订购日期)between1996and1998
groupbyyear(订单.订购日期)
selectyear(订单.订购日期)年份,
casewhenmonth(订单.订购日期)between1and3then'一季度'
whenmonth(订单.订购日期)between4and6then'二季度'
whenmonth(订单.订购日期)between7and9then'三季度'
whenmonth(订单.订购日期)between10and12then'四季度'end季度,
sum(订单明细.单价*订单明细.数量)金额
from订单,订单明细
where订单.订单ID=订单明细.订单IDandyear(订单.订购日期)between1996and1998
groupbyyear(订单.订购日期),
casewhenmonth(订单.订购日期)between1and3then'一季度'
whenmonth(订单.订购日期)between4and6then'二季度'
whenmonth(订单.订购日期)between7and9then'三季度'
whenmonth(订单.订购日期)between10and12then'四季度'end
你看你要用哪个
㈣ sql查询 ：销售额
1.select 销售价格*销售数据量 as 销售额 from 表名
2.select sum(销售价格*销售数据量) as 销售额 from 表名
-----
1.多条 2。一条。
㈤ 用SQL统计每种商品的销售总额
你写的基本差不多了，不过表连接的顺序最好按用到的前后来连接，不然影响效率
select P.ProctName, sum(OD.UnitPrice*OD.Quantity) total_sales
from Orders O
join OrderDetails OD on OD.OrderID=O.OrderID
join Procts P on P.ProctID=OD.ProctID
where OD.OrderDate>='2007-1-1'and OD.OrderDate < '2007-12-1'
group by P.ProctName
order by total_sales desc
㈥ 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
地区
, sum(case when 月=1月 then 销售额 else 0 end ) as sum_1
,sum(case when 月=2月 then 销售额 else 0 end ) as sum_2
,sum(case when 月=3月 then 销售额 else 0 end ) as sum_3
,sum(case when 月=4月 then 销售额 else 0 end ) as sum_4
,sum(case when 月=5月 then 销售额 else 0 end ) as sum_5
,sum(case when 月=6月 then 销售额 else 0 end ) as sum_6
,sum(case when 月=7月 then 销售额 else 0 end ) as sum_7
,sum(case when 月=8月 then 销售额 else 0 end ) as sum_8
,sum(case when 月=9月 then 销售额 else 0 end ) as sum_9
,sum(case when 月=10月 then 销售额 else 0 end ) as sum_10
,sum(case when 月=11月 then 销售额 else 0 end ) as 搜索sum_11
,sum(case when 月=12月 then 销售额 else 0 end ) as sum_12
from 表
group by 地区
㈧ 请问 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
year(ordertime)
年，
sum(Total)
销售合计
from
订单表
group
by
year(ordertime)
2、每月
select
year(ordertime)
年，
month(ordertime)
月,
sum(Total)
销售合计
from
订单表
group
by
year(ordertime)，
month(ordertime
3、每日
select
year(ordertime)
年，
month(ordertime)
月,
day(ordertime)
日，
sum(Total)
销售合计
from
订单表
group
by
year(ordertime)，
month(ordertime),
day(ordertime)
另外每日也可以这样:
select
convert(char(8),ordertime,112)
dt，
sum(Total)
销售合计
from
订单表
group
by
convert(char(8),ordertime,112)
如果需要增加查询条件，在from后加where
即可。
㈩ SQL按年度统计销售额 怎么写
缺字段，你俩表必须有个订单id关联，你自己查一下
如果存在这个订单id的话
比如查2013年的
selectyear(订单.订购日期)年份,sum(订单明细.单价*订单明细.数量)销售金额
from订单,订单明细where订单,订单id=订单明细.订单id
whereyear(订单.订购日期)=2013
groupbyyear(订单.订购日期)