22,209
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([Id] int,[TimeMinutes] int)
Insert #T
select 1,30 union all
select 2,60 union all
select 3,1440
Go
--测试数据结束
DECLARE @minute INT = 100;
SELECT *
FROM #T
WHERE Id = CASE
WHEN
(
SELECT TOP 1 Id FROM #T WHERE @minute < TimeMinutes ORDER BY TimeMinutes
) IS NOT NULL THEN
(
SELECT TOP 1 Id FROM #T WHERE @minute < TimeMinutes ORDER BY TimeMinutes
)
ELSE
(
SELECT MAX(Id) FROM #T
)
END;
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([Id] int,[TimeMinutes] int)
Insert #T
select 1,60 union all
select 2,1440
Go
--测试数据结束
DECLARE @minute INT=100
SELECT *
FROM #T
WHERE Id = CASE
WHEN @minute <= 60 THEN
1
ELSE
2
END;