NULLIF and COALESCE Chain?!
NULLIF and COALESCE can be CHAINED! NULLIF converts to NULL, COALESCE converts from NULL. This transformation chain will surprise you!
#sql #sqltricks #nullif #coalesce #functionchaining #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #nullhandling #advancedsql
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