销售量统计sql查询 sql统计查询

select 产品,sum(销售量列) as 销售量 from 表名 where 条件 group by 产品 order by 销售量 desc (去掉desc即升序)

select top 100 商品编号,销量,销售,sum(销售) 周销量 from tablename where 日期>getdate()-7 group by 商品编号 order by 周销量 asc 类似于此,具体的日期那些可能还要调试调试

这里有个同比和环比的例子.好好研究下就知道了. 表结构如下: ID DepartName(部门) Sales(销售量) SalesDate(销售日期) 1 营销一部 300 2006-7-1 2 营销二部.

select ID,sum(case when DATEDIFF(week,now(),销售时间)=1 then 销售量 end) 第一周,sum(case when DATEDIFF(week,now(),销售时间)=2 then 销售量 end) 第二周,sum(case when DATEDIFF(week,now(),销售时间)=3 then 销售量 end) 第三周,sum(case when DATEDIFF(week,now(),销售时间)=4 then 销售量 end) 第四周 from 表 where DATEDIFF(week,now(),销售时间)<5 group by ID;

sum函数取前三名就可以了啊

SELECT DISTINCT TOP 10 title, SUM(price) AS 产品总价, COUNT(*) AS 销量 FROM a GROUP BY title

与上月比即为环比,与上年同月比即为同比select sum(case when to_char(fdbs,'yyyy'). to_char(fdbs,'mm')-1 = 年月参数 then sshje else 0 end ) 上月销售额,sum(case .

SELECT B.id, name, sum(money) as total, '累计' as sort FROM B LEFT JOIN A ON B.id=A.id union all SELECT B.id, name, sum(money) as total, '当月' as sort FROM B LEFT JOIN A ON B.id=A.id WHERE date BETEEN '204-1-1' AND '2014-1-31' ORDER BY B.id

可以完成,思路如下:通过pid 商品编码分组,得到销售日期的每个月列,后用sum(case Fact_m WHEN 月份 then 数量end)来操作即可.--年度售额:select pid 商品编码.

select year(o.orderdate) year,count(distinct o.orderid) ordernumber,count(distinct o.customerid) ordernumber,cast(sum(od.unitprice*od.quantity*(1-od.discount)) as decimal(20,2)) amountfrom orders o join ＂order details＂ od on o.orderid=od.orderidgroup by year(o.orderdate) 答案如上