22,209
社区成员
发帖
与我相关
我的任务
分享
DECLARE @t TABLE (RequireA INT,RequireB INT,Charge INT)
INSERT @t SELECT 3,2,20
UNION ALL SELECT 6,4,50
UNION ALL SELECT 10,5,100
--设当前店家A的销售量为curA,B的销售量为curB
DECLARE @curA INT,@curB INT
SELECT @curA=7,@curB=5
SELECT TOP 1 * FROM @t WHERE RequireA<=@curA AND RequireB<=@curB ORDER BY Charge DESC
/*
RequireA RequireB Charge
----------- ----------- -----------
6 4 50
*/