Glossary: SQL Beyond the Basics
COALESCE
Also written: coalesce
Gives back the first of its values that isn't NULL. It lets you choose what NULL should mean, such as treating a never-asked email_opt_in as 0.
Glossary: SQL Beyond the Basics
Also written: coalesce
Gives back the first of its values that isn't NULL. It lets you choose what NULL should mean, such as treating a never-asked email_opt_in as 0.