----- 产品销售排行从高到低。 Select 产品,总售销额=Sum(售销额) from 表 Group by 产品 order by Sum(售销额) desc----- 产品销售排行 最高。 Select Top 1 产品,总售销额=Sum(售销额) from 表 Group by 产品 order by Sum(售销额) desc
select product,sum(sale_amt) as total_amt from table group by product
select top 1 * from (select 产品,sum(售销额) as 总售销额 FROM YOURTAHLE GROUY BY 产品) tmp order by 总售销额 desc
select product,sum(sale_amt) as total_amt from table group by product order by total_amt
select 产品,sum(销售量) as 销售量 from table group by 产品 order by sum(销售量) desc
select 产品,sum(销售量) as 销售量 from table group by 产品 order by sum(销售量) desc
select top 1 product,sum(sale_amt) as total_amt from [table] group by product order by sum(sale_amt)
select top 1 product,sum(sale_amt) as total_amt from [table] group by product order by sum(sale_amt)
各位,这张表是销售明细表,按你们的办法,只能查到一条数量最多的一个物料。 比如:物料A,在销售单0001里有三种物料A、B、C。销售单0002里有两种物料A、B。 这样销售明细表里就会记录如下: 单号 物料名称 单价 数量 0001 A 3 5 0001 B 2 6 0001 C 4 7 0002 A 3.5 5 0002 B 2 3
select 物料名称 ,sum(数量) as 总数量 from yourtable group by 物料名称 order by 总数量 desc select 物料名称 ,sum(数量*单价 )/sum(数量) as 物料平均值 from yourtable group by 物料名称 order by 物料平均值 desc
----- 产品销售排行从高到低。
Select 产品,总售销额=Sum(售销额) from 表 Group by 产品 order by Sum(售销额) desc----- 产品销售排行 最高。
Select Top 1 产品,总售销额=Sum(售销额) from 表
Group by 产品 order by Sum(售销额) desc
from table
group by product
from table
group by product
order by total_amt
from [table]
group by product
order by sum(sale_amt)
from [table]
group by product
order by sum(sale_amt)
比如:物料A,在销售单0001里有三种物料A、B、C。销售单0002里有两种物料A、B。
这样销售明细表里就会记录如下:
单号 物料名称 单价 数量
0001 A 3 5
0001 B 2 6
0001 C 4 7
0002 A 3.5 5
0002 B 2 3
这样的话,A总共是卖出了10个,B总共卖出了9个,C总共7个。
如何查出来?还有就是每张销售单的单价都可能不同,如何计算同一种物料的平均值?
select 物料名称 ,sum(数量*单价 )/sum(数量) as 物料平均值 from yourtable group by 物料名称 order by 物料平均值 desc