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

https://www.youtube.com/watch?v=36UQvnnAo5s

NULLIF and COALESCE Chain?! #SQL

YouTube

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

https://www.youtube.com/watch?v=Srv4R_xD-do

NULLIF5 5 Returns NULL?! #sqlwtf

YouTube

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

https://www.youtube.com/watch?v=k_DA2Kc9Rnc

COALESCE vs NULLIF Trap?! #codingchallenge

YouTube