#zerorows — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #zerorows, aggregated by home.social.
-
SUM - AVG With Zero Rows Returns WHAT?!
Aggregate functions with zero rows return NULL, not zero! SUM of nothing is NULL, not 0. This breaks aggregate logic! Watch!
#sql #sqltricks #database #sqltutorial #aggregate #zerorows #sqlquiz #codingchallenge #sqlshorts #sqlbugs #aggregatefunctions #sqlwtf