COALESCE(NULL, NULL, NULL) Returns WHAT?!
COALESCE with all NULLs returns something that defies logic! This function is supposed to return first non-NULL but what if all are NULL? Watch!
#sql #sqltricks #database #sqltutorial #coalesce #nullhandling #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullfunctions #sqlwtf
NULLIF(5, 5) Returns NULL?!
NULLIF with same values returns NULL instead of the value! This function behavior will break your brain. Watch the reveal!
#sql #sqltricks #database #sqltutorial #nullif #nullhandling #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullfunctions #sqlwtf
COALESCE vs NULLIF Trap?!
NULLIF converts values to NULL! COALESCE converts NULL to values. Together they create a transformation chain that will surprise you!
#sql #sqltricks #coalesce #nullif #nullhandling #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #nullfunctions #advancedsql
PrecisionSQL