Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
a8m88
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
4 ms
·
1.
▲
by
a8m88
13y ago
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)