Use
COALESCE, which returns the first not-null value e.g.SELECT COALESCE(sum(case when c.runstatus = 'Succeeded' then 1 end), 0) as Succeeded
Will set Succeeded as 0 if it is returned as
NULL.
0 comments:
Post a Comment