ExamGecko
Question list
Search
Search

Question 53 - Certified Data Cloud Accredited Professional discussion

Report
Export

Which of the following functions returns the first value from a list that isn't empty?

A.
CONCAT
Answers
A.
CONCAT
B.
COALESCE
Answers
B.
COALESCE
C.
REPLACE
Answers
C.
REPLACE
D.
FIND
Answers
D.
FIND
Suggested answer: B

Explanation:

COALESCE is the function that returns the first value from a list that isn't empty. It takes a list of values as arguments and returns the first non-empty value. For example, COALESCE(NULL, '', 'Hello', 'World') returns 'Hello'. If all values are empty, it returns NULL.

Reference:COALESCE

asked 23/09/2024
PATRICK ADUSEI
36 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first