COALESCE is the function that returns the first value from a list that isn’t empty. It takes a list of values asarguments and returns the first non-empty value. For example, COALESCE(NULL, ‘’, ‘Hello’, ‘World’) returns ‘Hello’. If all values are empty, it returns NULL. References: COALESCE
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit