34,590
社区成员
发帖
与我相关
我的任务
分享
select
case rank when 0 then (select * from todaytask where datediff("n",taskonlinetime,getdate()) <15 order by rank asc,addtasktime desc)
else (select * from todaytask order by rank asc,addtasktime desc)
from
todaytask
select *
from todaytask
where
taskonlinetime>=case
when rank=0
then dateadd(mi,-15,getdate())
else taskonlinetime
end
order by
rank asc,
addtasktime desc