خرید بک لینک

Vote count: 0

I Have got this query:
select

        case when EventCategory < 0.05 Then 'NOT INCL' ELSE 'OK' END AS Under3Min

     from (

           Select   
Sum(case when CustomEvent = 'without Stop' then cast(EventEndDateTime - EventStartDateTime as float)*24  else 0 end) as EventCategory
FROM tDataCategory

In this query I take from the table CustomEvent the `without Stop´ and take the sum of this duration. And in the first select I said if EventCategory is less than 0,05 then it should not included else include. And this gave me the right output. But I would like to exclude the "not Included" complete in the output. How can I exclude this issue?

asked 32 secs ago

برچسب: نویسنده: استخدام کار تاريخ: چهارشنبه 9 تير 1395 ساعت: 13:59

صفحه بندی