1.

What Is A Coalesce? What Is The Equivalent Of Oracle/db2 Coalesce Function In Sybase?

Answer»

Coalesce is also available in SYBASE This FUNCTIONS EVALUATES the listed expressions and RETURNS the first non­null value. If all the expressions are null, coalesce returns null 
USAGE: coalesce(expression, expression [, expression]…)
EXAMPLE: coalesce(initialqty,finalqty,middleqty)
Returns the first occurrence of a non­NULL value in either the initialqty or finalqty or middleqty

 

Coalesce is also available in Sybase This functions evaluates the listed expressions and returns the first non­null value. If all the expressions are null, coalesce returns null 
USAGE: coalesce(expression, expression [, expression]…)
EXAMPLE: coalesce(initialqty,finalqty,middleqty)
Returns the first occurrence of a non­NULL value in either the initialqty or finalqty or middleqty

 


Discussion

No Comment Found

Related InterviewSolutions