34,588
社区成员
发帖
与我相关
我的任务
分享
Create Table Sales(
GdCode Varchar(20),
Amount Money )
insert into Sales
select'A',20 Union ALL
select'B',18 Union ALL
select'C',15 Union ALL
select'D',14 Union ALL
select'E',12 Union ALL
select'F',10 Union ALL
select'G',6 Union ALL
select'H',5
select top 80 percent GdCode,sum(Amount) as Amount from sales group by GdCode order by 2 desc
SELECT TOP (80) PERCENT
GdCode
,SUM(Amount) AS Amount
FROM Sales
GROUP BY GdCode
ORDER BU SUM(Amount) DESC
select * from
(
select m.* , bl =
(select sum(customerid) from
(
select salespersonid , sum(customerid) customerid from sales.store group by salespersonid
) n where n.customerid >= m.customerid) * 100.0/ (select sum(customerid) from sales.store)
from
(
select salespersonid , sum(customerid) customerid from sales.store group by salespersonid
) m
) k where bl <= 80
DECLARE @t TABLE(
编号 INT IDENTITY,产品 VARCHAR(10),金额 DECIMAL(18,4))
INSERT INTO @t
SELECT '产品1',21.00 UNION ALL
SELECT '产品2',210.00 UNION ALL
SELECT '产品3',12.00 UNION ALL
SELECT '产品4',10.00
SELECT 产品 FROM @t WHERE 金额/(SELECT SUM(金额) FROM @t)>0.8
/*
产品
----------
产品2
*/
declare @samount decimal(18,2)
select @samount = sum(amount) from tb
select convert(varchar(7),date,120) as date,productid
from tb
group by convert(varchar(7),date,120),productid
having sum(amount) = @samount*0.4
建议你提供详细的资料:
例如表的结构,表之间的关系,测试数据,相关算法及需要的结果。
这样有助于我们理解你的意思,更主要的是能尽快让你获得答案或解决问题的方法。