What is the resemblance of COALESCE() function with IF-THEN-ELSE statement?

As we know that COALESCE() function returns first non-NULL value from the list of values. The following IF-THEN-ELSE statement is equivalent to COALESCE() function.

IF value1 is not NULL THEN
output = value1;
ELSIF value2 is not NULL THEN
output = value2;
ELSIF value3 is not NULL THEN
output = value3;
.
.
.
ELSIF valueN is not NULL THEN
output = valueN;
ELSE
output = NULL;
END IF;

Arushi

Published on 20-Feb-2018 13:34:18

• Related Questions & Answers
• Java if-then-else statement
• What is the if...else statement in JavaScript?
• What is if...else if... statement in JavaScript?
• What is the syntax of Python if...elif...else statement?
• What is basic syntax of Python if...else statement?
• Java if-else statement
• If-then-else in Lua Programming
• What is the ‘if...else if...else’ statement in Java and how to use it?
• Java if-else-if ladder statement
• IF ELSE statement in a MySQL Statement?
• Performing mathematical operations in MySQL IF then ELSE is possible?
• What is the purpose of COALESCE function? Explain with the help of an example.
• Explain if-else statement in C language
• What is the ‘if else’ statement in Java and how to use it?
• MySQL Mass Update with CASE WHEN/ THEN/ ELSE?