34,590
社区成员
发帖
与我相关
我的任务
分享
DECLARE @a INT =80
;WITH test ( 上限值, 代理费率 )
AS ( SELECT 0 ,
0.009
UNION ALL
SELECT 50 ,
0.008
UNION ALL
SELECT 100 ,
0.007
UNION ALL
SELECT 200 ,
0.005
)
SELECT TOP 1 *
FROM test
WHERE 上限值<=@a
ORDER BY 上限值 DESC
/*
上限值 代理费率
----------- ---------------------------------------
50 0.008
(1 行受影响)
*/
SELECT TOP 1 [代理费率] FROM #tb WHERE [上限值]<=100 ORDER BY [上限值] DESC
SELECT TOP 1 [代理费率] FROM #tb WHERE [上限值]<80 ORDER BY [上限值] DESC