Answer: Coalesce is a function tat returns first non-null value within the given list of values.
Example:
select param1, param2, Coalesce(param1*param2) from tableName;
It will receive only non-null value from param1 and param2
Asked In: Many Interviews |
Alert Moderator