a8m88
Re:Our SQL interview questions
on Tuesday May 28, 2013 @09:44AM (#5779969)
Using COALESCE here is correct, but sum() returns NULL if there were no non-NULL inputs, so COALESCE should go around it:
COALESCE(sum(salary), 0)