在where语句参数

的情况
select docket_number,aging from (
    select docket_number, 
        sum(cast(dateDiff(\"mi\",assigned,coalesce(completed,getdate()))/60.00 as decimal(20,2))) aging

    from ft_details_h 

    group by docket_number
)a where aging case  when  @hh <= 72 then  <= @hh else  > @hh end
嗨,大家好,当参数@hh小于或等于72时where语句应该老化<= @hh,而当老化大于72时where语句应该老化> @hh我如何满足where语句     
已邀请:

bab

        您可以执行以下操作:
where 
    (@hh <= 72 and aging <= @hh) or
    (@hh > 72 and aging > @hh)
    
        在您撰写问题时,请尝试:
   where (aging <= @hh And @hh <= 72) Or 
         (aging > @hh And aging > 72)
但我怀疑你有错字,实际上是
   where (aging <= @hh And @hh <= 72) Or 
         (aging > @hh  And @hh > 72)
    

要回复问题请先登录注册