Sybase Question: Download Questions PDF
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
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
Download Sybase Interview Questions And Answers
PDF
Previous Question | Next Question |
Explanation about replication server software? | How to swap a db device with another? |