coalesce function

Understanding Coalesce in SQL From Scratch - coalesce In this tutorial, we will explore the use of the COALESCE function in Data Explorer SQL queries COALESCE allows you to handle NULL values coalesce Returns the value of the first non-null expression in the list If all expressions evaluate to null, then COALESCE returns null

coalesce The COALESCE SQL function is an incredibly useful function that allows you to fill in unhelpful blank values that may show up in your data