一个SQL语句问题

Question

就是availibility这一列的值相乘排除0

Answer 1

SELECT @ret_actual_jph_b = avg(actual_jph),
        @ret_oee_b = avg(oee)
 FROM dbo.data 
 WHERE time_sequence between @start_hour_sequence and  @end_hour_sequenceset @ret_availibility_b=1
SELECT  @ret_availibility_b = @ret_availibility_b*case when isnull(availibility,0)=0 then 1 else availibility end
 FROM dbo.data 
 WHERE time_sequence between @start_hour_sequence and  @end_hour_sequenceselect @ret_actual_jph_b,@ret_availibility_b,@ret_oee_b