What is Coalesce?

 Posted by Rajni.Shekhar on 4/13/2012 | Category: Sql Server Interview questions | Views: 2523 | Points: 40
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 

Comments or Responses

Login to post response